Making a key load script

[Anonymous]

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]

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 · Accepted solution]

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]

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