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,
Been really struggling to get this working, hope you can help 🙂
So I have a table pulled from an API, this table includes details such as company name, company id, email and an order ID. This table also includes a column that contains the detail of the order ID (such as product ordered, quanitity etc) this column is named 'OrderRows'.
As you can see from the screenshot below inside the 'orderrows' column contains a record and within that record contains a record for each line item row.
As you can see from the formula below I have transformed all the records in the 'Orderrows' into one table.
What I need to do though is retain the information brought through in the first screenshot to each row of the second screenshot. (its the same query)
Any help at all? 🙂
Thank you
Will
Solved! Go to Solution.
Worked it out - for anyone who is struggling;
I inserted a custom column and used the below
Record.ToTable(Record.Combine(#"Removed Columns4"[orderRows]))
Ended up with my desired output;
Worked it out - for anyone who is struggling;
I inserted a custom column and used the below
Record.ToTable(Record.Combine(#"Removed Columns4"[orderRows]))
Ended up with my desired output;
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.