Forum Discussion

Krcmajster's avatar
Krcmajster
Icon for Helper IV rankHelper IV
7 years ago
Solved

Duplicate values from another table based on a list

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
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hello Krcmajster

     

    You would need to perform a CROSS JOIN:

     

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

2 Replies

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hello Krcmajster

     

    You would need to perform a CROSS JOIN:

     

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