topic Re: Convert records into rows and columns in Power Query

Convert records into rows and columns

pal95 — Wed, 13 Mar 2024 15:39:51 GMT

Hi, I have the following query:

There are about 370 records, and each contains the same 3 columns:

I would like to unzip it into 370 rows and 3 columns, so my columns are: OEE, Shift, Timestamp, and my rows are just the values for each record. Is that possible somehow? Thank you

Re: Convert records into rows and columns

slorin — Wed, 13 Mar 2024 16:24:42 GMT

Hi,

https://learn.microsoft.com/en-US/powerquery-m/table-fromrecords

Stéphane

Re: Convert records into rows and columns

pal95 — Thu, 14 Mar 2024 08:10:26 GMT

Hi, how to scale that into 370 records? Could you please provide a pattern so I can follow that? thank you

Re: Convert records into rows and columns

slorin — Thu, 14 Mar 2024 08:45:30 GMT

Hi, pal95

= Table.FromRecords(Source[rows])

Stéphane

Re: Convert records into rows and columns

pal95 — Thu, 14 Mar 2024 09:19:34 GMT

Sorry, but it doesn't work.

What is the source and what should stand for rows?

Re: Convert records into rows and columns

pal95 — Thu, 14 Mar 2024 11:24:34 GMT

This was bad advice, I used a custom column to create 3 columns from records like Record.Field([Column1], "Shift")