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

[nikhilgarg]

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

[arulsettu]

hi

try this

Drop Field column name;

[prma7799]

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

[nikhilgarg]

HEy,

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

What to do ?

[jensatonce]

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

[nikhilgarg]

HEy,

Yeah it is empty with no spaces.

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

Thanks

[kavita25 · Accepted solution]

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

[MarcoWedel]

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

[nikhilgarg]

Hey,

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

Thanks