topic classifying and lookup tables in QlikView

classifying and lookup tables

josephinetedesc — Wed, 11 Mar 2015 12:42:24 GMT

I am having to classify about 10000 lines of data.

So ... I have a flowchart of what I need to do. First I apply a lookup table, for one column.of data, next i apply another lookup table for another column in the same table, next I apply a third lookup table for another column in the same table.

Then

I concatenate all three columns and apply another code based on the concatenation.

I am still at the stage of asking that users are consistent with their coding and I expect this will eventually be less than 50 possibilites. I am doing this in excel/Qlkview but it seems very labour intensive. Is there an easier way?

I will try and put together a demo.

Re: classifying and lookup tables

Gysbert_Wassenaar — Wed, 11 Mar 2015 13:05:16 GMT

If you have the lookup tables then it sounds fairly straightforward to me:

Lookup1:

mapping load Key1, Value1 FROM LookupSource1;

Lookup2:

mapping load Key2, Value2 FROM LookupSource2;

Lookup3:

mapping load Key3, Value3 FROM LookupSource3;

Data:

LOAD ...some fields...,

applymap('Lookup3', applymap('Lookup1', Field1) & '|' & applymap('Lookup2', Field2)) as FieldX,

...some more fields...

FROM SourceTable;

Re: classifying and lookup tables

josephinetedesc — Wed, 11 Mar 2015 13:11:34 GMT

Thanks Gysbert, so basically the same as if I were doing it in Excel - I can see though that there are advantages in using Qlik.

Thank you