Forum Discussion
Sattu_98
2 years agoNew Member
how to transform the data having different component in rows?
Hi, I am trying to transform the data in which major compoenent are in row need that comomnet in cloume. I am attaching image for the same. I am recving this data from PLC. Kindly provide the so...
AlienSx
Super User
2 years agohi, Sattu_98
let
Source = currently_getting,
columns = Table.ToColumns(Source),
split = List.Split(columns, 6),
combine = List.Transform(List.Zip(split), List.Combine),
to_tbl = Table.FromColumns(combine, List.FirstN(Table.ColumnNames(Source), 6))
in
to_tbl
or
let
Source = currently_getting,
z =
Table.FromList(
List.Combine(
Table.ToList(Source, (x) => List.Split(x, 6))
),
(w) => w,
List.FirstN(Table.ColumnNames(Source), 6)
)
in
z