topic Re: Concatenate the same table for each row from another table in QlikView

Concatenate the same table for each row from another table

Wed, 17 Aug 2016 18:05:08 GMT

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!

Re: Concatenate the same table for each row from another table

kaushiknsolanki — Wed, 17 Aug 2016 18:15:42 GMT

Hi,

You just need to do below thing.

Load Procedure_Code from Table A;

Join

Load Campus, Date from Table B;

Regards,

Kaushik Solanki

Re: Concatenate the same table for each row from another table

MarcoWedel — Thu, 18 Aug 2016 00:03:59 GMT

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