Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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: