Forum Discussion
create column in table 2 with value from table 1
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
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
thank you
thought also was the best way as it seems I can not import value in it
many thx
br
F.