topic Re: How to del column having empty values at data transformation step ?? in QlikView

How to del column having empty values at data transformation step ??

nikhilgarg — Tue, 13 Jan 2015 07:28:02 GMT

Hey,

I have an excel sheet . In that , in 7th column there are no values. I want to del that.

How can i achieve this by Data transformation ??

I tried Using Codition delete, select Compare with value and in column 7 and then is empty. Then i click add.

But it clears all data except column names.

What to do ??

Thanks

Re: How to del column having empty values at data transformation step ??

arulsettu — Tue, 13 Jan 2015 07:36:39 GMT

try this

Drop Field column name;

Re: How to del column having empty values at data transformation step ??

prma7799 — Tue, 13 Jan 2015 07:39:55 GMT

1) select excel file from table files

2) next

3)enable transformation step

4) garbage then select column

5) then conditional delete

6) add a condition

7) ok

Thanks

Re: How to del column having empty values at data transformation step ??

nikhilgarg — Tue, 13 Jan 2015 07:44:35 GMT

HEy,

I tried your way but the 7th column is not deleting.

What to do ?

Re: How to del column having empty values at data transformation step ??

jensatonce — Tue, 13 Jan 2015 07:52:37 GMT

NikHil Garg are you sure it is empty and no space in it ?

Re: How to del column having empty values at data transformation step ??

nikhilgarg — Tue, 13 Jan 2015 07:59:55 GMT

HEy,

Yeah it is empty with no spaces.

Although i have attached the file . It is the last(7th) column.

Thanks

Re: How to del column having empty values at data transformation step ??

kavita25 — Tue, 13 Jan 2015 09:54:47 GMT

Hi,

Just click on the 7th column as shown in the screenshot.

After that click on "Delete Marked" button on the left side.

Regards,

kavita

Re: How to del column having empty values at data transformation step ??

MarcoWedel — Tue, 13 Jan 2015 17:19:12 GMT

Hi,

you could also just omit the column name in the load statement:

LOAD AccountName,
    [Total Invoiced Revenue],
    [Total Cost],
    [Gross Margin],
    [Actual Margin%],
    [Quoted Margin%]
FROM [http://community.qlik.com/servlet/JiveServlet/download/693704-144770/Bottom%205%20sales.xls]
(biff, embedded labels, table is Sheet1$);

hope this helps

regards

Marco

Re: How to del column having empty values at data transformation step ??

nikhilgarg — Wed, 14 Jan 2015 05:26:37 GMT

Hey,

Yeah i know about that but want to do that at transformation step only.

Thanks