Create one table from 2 tables (inner join)

Question

Hello,&nbsp;I have 2 tables with:&nbsp;Table1id&nbsp; Col1 Col2 Col31&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; BB&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; 41&nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; 52&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; 102&nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; AA&nbsp; &nbsp; &nbsp; 62&nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; 82&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; 103&nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; BA&nbsp; &nbsp; &nbsp; 63&nbsp; &nbsp;H&nbsp; &nbsp; &nbsp; FC&nbsp; &nbsp; &nbsp; 8&nbsp;Table2id&nbsp; Col1 Col2 Col31&nbsp; &nbsp;XX4&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp;AA5&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp;41&nbsp; &nbsp;BB1&nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp;53&nbsp; &nbsp;AC1&nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; 103&nbsp; &nbsp;BD2&nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; 63&nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; CC&nbsp; &nbsp; &nbsp; 8&nbsp;Result expected:Table_Resid&nbsp; Col31&nbsp; &nbsp;21&nbsp; &nbsp;41&nbsp; &nbsp;53&nbsp; &nbsp;63&nbsp; &nbsp;8&nbsp;I need to create a table with column id and Col3 from Table1 but only where id included in table2.A kinf of : select id,col3 from table1 inner join table2 on table1.id=table2.id&nbsp;Thanks for your help.&nbsp;&nbsp;

anonymous · Accepted Answer

HI&nbsp;Madxfr&nbsp;,
You can use values function to extract table 2 id and use 'in' operator to compare with these fields:
NEW Table =
SELECTCOLUMNS (
    FILTER ( Table1, [id] IN VALUES ( Table2[id] ) ),
    "id", [id],
    "Col3", [Col3]
)
Regards,
Xiaoxin Sheng

Forum Discussion

Create one table from 2 tables (inner join)

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

inner join

Creating Date Tables