Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all
very super basic question
I do have Table 1 with
I do have table to Table 2 with
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
Solved! Go to 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
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.