Forum Discussion

pal95's avatar
pal95
Helper III
2 years ago
Solved

Convert records into rows and columns

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

 

 

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

5 Replies