Forum Discussion
Helper IAppend expanded records to existing table
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
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;
1 Reply
WillBatesHydroWorked 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;