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