Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III

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

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

ID

1111

2222

3333

4444

 

Tables 2:

BU

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

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

Maye be :

Table1:
load * inline [
ID

1111

2222

3333

4444
];
 
join

load * inline [
BU

1234

4321

5678
]

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

Maye be :

Table1:
load * inline [
ID

1111

2222

3333

4444
];
 
join

load * inline [
BU

1234

4321

5678
]

 

output :

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post