Concatenate the same table for each row from another table

[#1]

Hi everyone,

My question stated in the tittle could also being asked as merge two tables without key. Is there a loop function to complete this?

I have a tableA with one field "Procedure code". and I have tableB with two fields "Campus" and "Date". I want to repeat the tableB for each row in tableA. The tables like this:

tableA:             

Procedure code
Proc1
Proc2
Proc3

tableB:

Campus	Date
A	201501
B	201502
C	201503

I want the merged table look like this:

Procedure code	Campus	Date
Proc1	A	201501
Proc1	B	201502
Proc1	C	201503
Proc2	A	201501
Proc2	B	201502
Proc2	C	201503
Proc3	A	201501
Proc3	B	201502
Proc3	C	201503

Thank you in advance!

[kaushiknsolanki · Accepted solution]

Hi,

You just need to do below thing.

Load Procedure_Code from Table A;

Join

Load Campus, Date from Table B;

Regards,

Kaushik Solanki

[MarcoWedel]

Hi,

loading your tables as data islands you could also generate this table in the front end:

tableA:
LOAD * FROM [https://community.qlik.com/thread/229450] (html, codepage is 1252, embedded labels, table is @1);

tableB:
LOAD * FROM [https://community.qlik.com/thread/229450] (html, codepage is 1252, embedded labels, table is @2);

hope this helps

regards

Marco