topic Re: Remove fields from a table mentioned in other table in QlikView

Remove fields from a table mentioned in other table

ferha_jafri — Mon, 01 Oct 2018 06:58:54 GMT

Hello Experts,

I have a requirement in which I want to exclude columns present in a table in one column and remove them from the main table.

I am attaching a sample in which I have a MainTable from which I want to exclude fields present in other table RemoveColumns in Columns Field. So the Final table will have columns as

ProductID , Product, Shape, Price, Order.

Thanks in advance

Ferha

Re: Remove fields from a table mentioned in other table

andrey_krylov — Mon, 01 Oct 2018 07:05:45 GMT

Hi, maybe like this

FOR vCounter = 0 to NoOfRows('RemoveColumns')-1

CurrentField = Peek('Columns', vCounter,'RemoveColumns');

Drop Field [$(CurrentField)] From [MainTable];

Re: Remove fields from a table mentioned in other table

tresB — Mon, 01 Oct 2018 07:10:25 GMT

Try like:

RemoveColumns:

LOAD

Concat(Columns, ',') as ConcatCols

INLINE [

Columns

Quantity

SalePerson

OrderDetail

];

Let vCols=Peek('ConcatCols');

DROP Fields $(vCols), ConcatCols;

Re: Remove fields from a table mentioned in other table

marcus_sommer — Mon, 01 Oct 2018 07:15:48 GMT

By large datasets the reverse way of just loading the needed fields might be more suitable as loading everything and removing than the unwanted fields. Take a look on the suggestion from Tresesco which will also work for the load-statement.

- Marcus