Applying Multiple Labels To My Data

[mccook]

Hi,

I have a more complex version of the data below (more catcodes/fields and 40 million rows of data):

Date	Ledger	Balance	CatCode1	CatCode2	Object	Subsidiary	Cost Centre
31/01/2019	AA	1,000	100	111	2120	01	3000200
14/02/2019	BB	2,000	200	111	2150	03	3000200
22/10/2019	CC	3,000	300	222	2169	02	3001300

I have another data source which holds the labels (in a google sheet and I use Qlik Web connectors, so the users can update the Labels/CatCodes)

The data is a more complex version of below (100s of labels and more cat codes/fields):

Label	Sort Order	Bold	CatCode1	CatCode2	Object	Subsidiary
Sales	1	NULL	100	111	ALL	ALL
Cost	2	NULL	200	111	2150	03
Total	3	Y	ALL	111	ALL	ALL

ALL = Any value in this field

I need to join the labels to my transactional data in an efficient way (my successful results take over 5 hrs so far... e.g. filling in the ALLs with all available cat codes creates a huge table or applying the labels with hard coded resident loads for each one takes 30 seconds or so each and there are hundreds of labels... )

The result is to look something like below:

Date	Ledger	Balance	Cost Centre	Label	Sort Order	Bold
31/01/2019	AA	1,000	3000200	Sales	1	NULL
14/02/2019	BB	2,000	3000200	Cost	2	NULL
31/01/2019	AA	1,000	3000200	Total	3	Y
14/02/2019	BB	2,000	3000200	Total	3	Y
22/10/2019	CC	3,000	3001300

Any advice is appreciated.

Thanks,

Dean

[DeeptiRao]

Hi,

How are you getting the codes, you are joining the two tables or linking them.

Kindly share your script.

[mccook · Accepted solution]

We have solved this by adding ALL to the other side of the table also, thanks for your response