create column in table 2 with value from table 1

[Thrasymaque]

Hi all

very super basic question 

I do have Table 1 with

• project ID ,
• name,
• Cost.

I do have table to Table 2 with 

• project ID ,
• Start.

I would like to create a new column (in the advanced editor) in table 2 getting the name Info from column 1

Can you please telle me the formula I need to use ?

thanks a million 

fred

[Jimmy801 · Accepted solution]

Hello @Thrasymaque 

you can use Table.NestedJoin to join both tables. Afterwards you can expand the columns you needed from the newly created column. here an example (not tested)

JoinTables = Table.NestedJoin(Table1, {"project ID"}, Table2, {"project ID"}, "Table2", JoinKind.LeftOuter)

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Thrasymaque]

thank you 

thought also was the best way as it seems I can not import value in it

many thx

br

F.