Create a master table of keys

Wed, 05 Mar 2014 06:53:08 GMT

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

Table 2: Channel (Channel can take 2 values)

Channel

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

Re: Create a master table of keys

MK_QSL — Wed, 05 Mar 2014 07:01:21 GMT

T1:

Load * Inline

[

Status

];

JOin

Load * Inline

[

Channel

];

Final:

Load

Status,

Channel,

Status &'-'&Channel as Key

Resident T1;

Drop Table T1;

Wed, 05 Mar 2014 07:36:17 GMT

Thanks a lot, Manish! 🙂