topic Can someone help me with this script please? in QlikView

Can someone help me with this script please?

Thu, 16 Jun 2011 17:13:34 GMT

Hello this is the issue I am facing, what if I want to remove these highlighted fields at the load script level, so that they are not used anywhere in the application and they cant be dropped at the source?? They are coming from the SQL Table, Dashboard, Assets: I have the below load script.

Dashboard:

Load

Assets,
Profits,
Budget,
Other tables

From dbo.xyz table.

Thanks to you all in Advance

Can someone help me with this script please?

Thu, 16 Jun 2011 17:36:43 GMT

DROP FIELDS [Fees], [VAT on fees], [Whole Book] FROM Assets;

I don't really know what you mean by "and they cant be dropped at the source". If you mean they don't get droppped from dbo.xyz.table but they do get dropped from Assets, this is what you want.

Can someone help me with this script please?

Thu, 16 Jun 2011 20:18:58 GMT

try

Load

Assets,
Profits,
Budget,
Other tables

From dbo.xyz table

where Assets <> 'Fees' and

where Assets <> 'VAT on fees' and

where Assets <> 'Whole book';