Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate the same table for each row from another table

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:

CampusDate
A201501
B201502
C201503

I want the merged table look like this:

Procedure codeCampusDate
Proc1A201501
Proc1B201502
Proc1C201503
Proc2A201501
Proc2B201502
Proc2C201503
Proc3A201501
Proc3B201502
Proc3C201503


Thank you in advance!

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

You just need to do below thing.

Load Procedure_Code from Table A;

Join

Load Campus, Date from Table B;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
kaushiknsolanki

Hi,

You just need to do below thing.

Load Procedure_Code from Table A;

Join

Load Campus, Date from Table B;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
MarcoWedel

Hi,

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

QlikCommunity_Thread_229450_Pic1.JPG

QlikCommunity_Thread_229450_Pic2.JPG

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