Is there any way to load the fields of a resident table dinamically ? (including and excluding the fields as you want)

[marcel_olmo]

Hey Guys. I just want to know if is it possible to do the following Idea :

I have a table like this :

MyTable :

load * inline [

A1, A2, A3, A4, AN , fieldToExclude, otherField

1 , 2 , 3 , 4 , 5 , lorem, ipsum

10 , 20 , 30 , 40 , 50 , lorem2, ipsum2

100 , 200 , 300 , 400 , 500 , lorem3, ipsum3

];

When the fields A1,..., AN are autogenerated fields with dynamic names, and the fieldToExclude has some KeyWords to detect this is the field I want to delete.

If I do this, is fine and it works:

MyTable2 :

load *

resident MyTable;

But my point is :

Is there any way to load the table dinamically with some kind of regular expression to load all the fields of the previous table except the ones that contains the name "fieldToExclude" ??

Many thanks in advance !!

[sparur · Accepted solution]

Hello, Marcel.

I think you can load ALL fields:

MyTable2:

LOAD * RESIDENT MyTable;

and then drop some fields:

DROP FIELD fieldToExclude FROM MyTable2;

[marcel_olmo]

Thank you very much Sparur, sometimes it's as easy as it seems.

I got confused if this was possible because there is no color clue to find out these are protected words, as you can see :

Many thanks.

See you around!!

[sparur]

Marcel,

unfortunately, highlighting in QlikView doesn't work properly always.