topic Re: Making a key load script in QlikView

Making a key load script

Anonymous — Tue, 23 Feb 2016 14:39:16 GMT

Hi,

I have Client number , Unit Number (JB) and Small Unit Number (LP) as columns in one table.

I would like to have the key like this below but in one column:

Client number & JB

Client number & LP

I want to do this in one table , is it possible?

I can have key CLient number & JB & LP but this would be not what i want.

Maybe i have to concatenate a lot of small tables ?

Please help,

Jacek Antek

kaushiknsolanki — Tue, 23 Feb 2016 20:04:59 GMT

Hi,

If all 3 fields, Client, JB and LP are from same table you can try this.

Load Client,

JB,

JP,

Client &JB as Key1,

Client & JP as Key2

From Data;

Regards,

Kaushik Solanki

swuehl — Tue, 23 Feb 2016 20:12:03 GMT

You can load your table two times and create your key first using Client number & JB, then using Client number & LP:

TABLE:

LOAD Client number & JB as Key,

...

FROM YourTable;

CONCATENATE (TABLE)

LOAD Client number & LP as Key,

...

FROM YourTable;

Not sure if this is what you really want, it may duplicate measures.

Anonymous — Wed, 24 Feb 2016 06:59:23 GMT

Hi,

This is not what i meant. Fields Key 1 and Key 2 should be in one column.

thank You for your help.

Jacek Antek