Ignoring few columns and inserting few columns from excel sheet using transform script.

[haranath jivvi]

we are loading data from excel sheet to alm_hardware table using transform script. we are avoiding duplicate record insertion making Coalesce true for Serial number. 

While inserting data from source table to target table, while transforming i need to ignore few columns and need to insert few columns target will be having empty or null. but it is not working as expected. could you please help us. 

[Jaspal Singh]

Hi,

Did you try Copy Empty Fields on transform map? This will copy columns with empty values.

[haranath jivvi]

Hi Jaspal Ji,

Yes, i did. My requirement is while loading data into target table. through transform map on run script  

1) Override fileds (Serial Number, Model)

2) If Existing filed Value was Empty then only override - Location, company

3) Always override (state, substate etc....)

Could you please help me 

[haranath jivvi]

Hi All,

I have found solution to this using custom script in transform script.

If anybody have similar requirement/working with transform map, let me know, i can help them out.