Duplicate values from another table based on a list

[Krcmajster]

Hi everyone

I want to create a table where the values are duplicated based on a list. I believe it’s easier on example

Table1
Id value1 value2.
1
2
3


List on which duplicates are made (not a table, just need these values)
A
B
C

Table2
ID. List value
1. A
1. B
1. C
2. A
2. B
2. C
3. A
3. B
3. C

Thanks

[LivioLanzo · Accepted solution]

Hello @Krcmajster

You would need to perform a CROSS JOIN:

Table = 
CROSSJOIN(
    DATATABLE( "ID", INTEGER, { {1}, {2}, {3} } ),
    DATATABLE( "Value", STRING, { {"A"}, {"B"}, {"C"} } )
)

[Krcmajster]

Thanks @LivioLanzo I adjusted a bit but that did the trick