classifying and lookup tables

[josephinetedesc]

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.

Jo

[Gysbert_Wassenaar]

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;

[josephinetedesc]

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

Jo