Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
hospitalfinance
Contributor
Contributor

Vector multiplication with Strings

Good afternoon,

i have a problem that i can not solve on my own.

I want to create a data model with two tables, which I already loaded. Table A  and Table B. My target should be Table C with two columns, which include all combinations of Table A and Table B.

Table A:

Person1

Person2

Table B:

01.01.1990

01.02.1990

Target Table C:

Person1         01.01.1990

Person1         01.02.1990

Person2         01.01.1990

Person2         01.02.1990

 

I hope that you can give me al solution.

 

Best regards.

1 Reply
Taoufiq_Zarra

@hospitalfinance 

you can just add a join between two table

TableA:
load * inline [
Person
Person1
Person2
];

join
TableB:

load * inline [
Date
01.01.1990
01.02.1990
];

output:

Taoufiq_Zarra_0-1628678108580.png

 

Regards,
Taoufiq ZARRA

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

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