Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables:
Customer |
---|
A |
B |
C |
Periode |
---|
Jan-2013 |
Feb-2013 |
Mar-2013 |
and want to get this result:
Customer | Periode |
---|---|
A | Jan-2013 |
A | Feb-2013 |
A | Mar-2013 |
B | Jan-2013 |
B | Feb-2013 |
Any idea how a script should look like. I was thinking to do it with a JOIN, but I don't find a solution.
Thanks for your help
Seems like its working
Script I used:
Table:
LOAD * Inline [
Customer
A
B
C
];
Join (Table)
LOAD * Inline [
Periode
Jan-2013
Feb-2013
Mar-2013
];
Where did C go??? or are you just showing partial output? From your description you seem to be looking for a Cartesian Product?
May be this:
Table:
LOAD Customer
FROM....;
Join (Table)
LOAD Periode
FROM.....;
yes you are right, just a partial output.
I tried it, but it doesn't worked.
Seems like its working
Script I used:
Table:
LOAD * Inline [
Customer
A
B
C
];
Join (Table)
LOAD * Inline [
Periode
Jan-2013
Feb-2013
Mar-2013
];
Yes, thank you.