Create a master table of keys

[#1]

Hi,

I need to create a key table that combines all possible values of 3 to 4 variables.

The values for every variable are present in separate tables/

Table 1: Status (Status can take 3 values)

Status

1

2

3

Table 2: Channel (Channel can take 2 values)

Channel

A

B

Desired Output: Key Table

Status       Channel      Key

1               A               1-A

1               B               1-B

2               A               2-A

2               B               2-B

3               A               3-A

3               B               3-B

Can someone guide me on the script to use for this.

Thanks.

Regards,

Shweta

[MK_QSL · Accepted solution]

T1:

Load * Inline

[

  Status

  1

  2

  3

];

JOin

Load * Inline

[

  Channel

  A

  B

];

Final:

Load

  Status,

  Channel,

  Status &'-'&Channel as Key

Resident T1;

Drop Table T1;

[#3]

Thanks a lot, Manish! 🙂