Remove some Null column in Transformation wizard

[user-azadi]

Hi ....

How we can remove many Null column (with no header)  in Transformation with condition delete option alltogether , and can we do it in edit script ?

for example i have excel file that contains 20 column with Null value and no header.

[prma7799]

This can do from using "Enable Transformation Step"

Go to >> Enable Transformation Step >> Select column which you want to delete >> condition >> write your condition here.

[avinashelite]

if its a one time load then I prefer to do it manually ..if its changing dynamically ? then shall the sample files will check and let you know the solution

[Anil_Babu_Samineni]

There is option called PopUp() to remove blank data and Columns too while loading.

[user-azadi]

plz tell me what expression condition i must writ in Condition Delete?

[prma7799]

Try like this

Go to >> Enable Transformation Step >> Select column which you want to delete >> compare with value >>Lenght is >> add

[user-azadi]

Yes changing dynamically,

here is sample file...

[user-azadi]

Thanks for your answer , but this option just delete one column with condition.i want delete all Null column immediatly.

[avinashelite · Accepted solution]

check this document

Remove Empty columns (All Null values) in script dynamically