topic Load only fields with specific prefix in QlikView

Load only fields with specific prefix

zagzebski — Tue, 02 Feb 2016 17:48:42 GMT

Is there any (automated) way of doing a load of fields with specific prefixes. I have a table (example Table A below) that is constantly modified and rather than have to add and removes fields every time it would be great screen the fields (as an example in Table B below where it would automatically only pull in fields beginning with MI):

For example:

Table A:

Load

MI Customer,

MI Region ,

MI Amount,

Sales,

Employee,

Budget

From Table_Source;

Table B:

Load

{only fields beginning in MI}

Resident Table A:

Re: Load only fields with specific prefix

Gysbert_Wassenaar — Tue, 02 Feb 2016 18:02:16 GMT

Yes, that's possible.

[Table A]:

LOAD * INLINE [

MI One, MI Two, MI Three, Four, Five

1,2,3,4,5

];

LET vFields = NoOfFields('Table A');

For j=1 to $(vFields)

LET vField = FieldName($(j),'Table A');

WHEN FindOneOf('$(vField)','MI') LET vFieldList = '$(vFieldList)' & ', ' & '[$(vField)]';

LET vFieldList = Mid('$(vFieldList)',2);

[Table B]:

LOAD

$(vFieldList)

RESIDENT

[Table A]

;

SET vFieldList=;

Re: Load only fields with specific prefix

zagzebski — Tue, 02 Feb 2016 18:06:51 GMT

Thanks!!