Forum Discussion

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
4 years ago
Solved

Concatenate two data from different tables without reference

Concatenate two data from different tables without reference Sample data and output Style No.(Table1) Region(Table2) Concatenate(Output) ABCD03700I BIHAR ABCD03700I,BIHAR ABCD06299 BL...
  • amitchandak's avatar
    amitchandak
    4 years ago

    arvindarvind24 , crossjoin

     

    new table = Crossjoin(Table1, Table2)

     

    or

     

    new table = addcolumns(Crossjoin(Table1, Table2) , "Concat", [Style No] & ", " & [Region]) 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi arvindarvind24 
    Here is a sample file with the solution https://we.tl/t-IHBj2FTgwN

     

    Concatenated Table = 
SELECTCOLUMNS (
    GENERATE (
        Table1,
        ADDCOLUMNS ( 
            Table2,
            "@Concatenate", Table1[Style No.] & "," & Table2[Region]
        )
    ),
    "Concatenate", [@Concatenate]
)

     

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi arvindarvind24 
Here is a sample file with the solution https://we.tl/t-IHBj2FTgwN

 

Concatenated Table = 
SELECTCOLUMNS (
    GENERATE (
        Table1,
        ADDCOLUMNS ( 
            Table2,
            "@Concatenate", Table1[Style No.] & "," & Table2[Region]
        )
    ),
    "Concatenate", [@Concatenate]
)

 

 

arvindarvind24's avatar
arvindarvind24
Icon for Helper II rankHelper II
4 years ago

Hi tamerj1 ,

 

Thank you for ur Solution it's working fine and if we need to add a new data from table 3 to

Concatenate.