topic Re: Remove some Null column in Transformation wizard in QlikView

Remove some Null column in Transformation wizard

user-azadi — Tue, 14 Nov 2017 05:08:25 GMT

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.

Re: Remove some Null column in Transformation wizard

prma7799 — Tue, 14 Nov 2017 05:43:07 GMT

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.

Re: Remove some Null column in Transformation wizard

avinashelite — Tue, 14 Nov 2017 05:50:47 GMT

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

Re: Remove some Null column in Transformation wizard

Anil_Babu_Samineni — Tue, 14 Nov 2017 06:01:03 GMT

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

Re: Remove some Null column in Transformation wizard

user-azadi — Tue, 14 Nov 2017 06:09:32 GMT

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

Re: Remove some Null column in Transformation wizard

prma7799 — Tue, 14 Nov 2017 06:21:26 GMT

Try like this

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

Re: Remove some Null column in Transformation wizard

user-azadi — Tue, 14 Nov 2017 06:30:06 GMT

Yes changing dynamically,

here is sample file...

Re: Remove some Null column in Transformation wizard

user-azadi — Tue, 14 Nov 2017 06:59:29 GMT

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

Re: Remove some Null column in Transformation wizard

avinashelite — Tue, 14 Nov 2017 09:42:19 GMT

check this document

Remove Empty columns (All Null values) in script dynamically