Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
You just need to do below thing.
Load Procedure_Code from Table A;
Join
Load Campus, Date from Table B;
Regards,
Kaushik Solanki
Hi,
You just need to do below thing.
Load Procedure_Code from Table A;
Join
Load Campus, Date from Table B;
Regards,
Kaushik Solanki
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