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.
Hello,
I cannot use join to get my expected outcome since rows has no primary key which are matching.
What I have:
Table A
Date | Day | |
16.01.2023 | Monday | |
17.01.2023 | Tuesday | |
18.01.2023 | Wednesday | |
19.01.2023 | Thursday | |
20.01.2023 | Friday |
Table B
Task | ID | |
Mount | 1 | |
BUY | 2 | |
FETCH | 3 |
How to get this table:
Date | Day | Task | ID | |||
16.01.2023 | Monday | Mount | 1 | |||
16.01.2023 | Monday | BUY | 2 | |||
16.01.2023 | Monday | FETCH | 3 | |||
17.01.2023 | Tuesday | Mount | 1 | |||
17.01.2023 | Tuesday | BUY | 2 | |||
17.01.2023 | Tuesday | FETCH | 3 |
Thank you very much in advance.
Best.
Solved! Go to Solution.
>>Table A >> Add Custom Column >> With Below Code And Pic.
>> After Create Column >> Expand Table Column >> With Need You Column.
M Code : #"Table B"
@Applicable88 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
I am trying to do this exact thing, but the accepted solution doesn't work because I can't complete the step in the first picture. The system greys out the "OK" button and displays an error. But clicking "Show error" does nothing. Any idea what I should do?
That worked. Thanks.
>>Table A >> Add Custom Column >> With Below Code And Pic.
>> After Create Column >> Expand Table Column >> With Need You Column.
M Code : #"Table B"
@Applicable88 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.