Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I want to create a new Table by using the Loading Scirpt.
For Example: Initially I have loaded a table containig several "Customers"
| CustomerID |
| 001 |
| 002 |
| ... |
Now, I have another loaded table containing "Information types":
| Information |
| Age |
| Gender |
| ... |
My objective is to create a New table looking like this:
| CustomerID | Information |
| 001 | Age |
| 001 | Gender |
| 002 | Age |
| 002 | Gender |
| ... | ... |
Is this possible?
Best regards, Jacob
What data links the two tables? Or do you just want to join every row of Information Types with every row of the Customer table?
-Rob