How to create a table and making multiple entries for each line

justcotto — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I am trying to create a table to use for section access. I have a table with IDs and I have a separate list of Business Units. I want to create a table that stores a row for each ID and BU. Example:

Table 1

1111

2222

3333

4444

Tables 2:

1234

4321

5678

Table I want:

ID BU

1111 1234

1111 4321

1111 5678

2222 1234

2222 4321

2222 5678

3333 1234

3333 4321

3333 5678

Re: How to create a table and making multiple entries for each line

Taoufiq_Zarra — Mon, 31 Aug 2020 20:58:09 GMT

Maye be :

Table1: load * inline [ ID 1111 2222 3333 4444 ]; join load * inline [ BU 1234 4321 5678 ]

output :

topic How to create a table and making multiple entries for each line in QlikView

How to create a table and making multiple entries for each line

Re: How to create a table and making multiple entries for each line