Can someone help me with this script please?

[#1]

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

[#2]

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.

[#3]

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';