Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all hi,
I faced with problem in data preparation for our dashboards.
I Have dataset like this.
Name Value
A | X |
B | Y |
C | Z |
A | V |
B | O |
C | B |
and i need to tranform it for propper calculation like this:
A | B | C |
X | Y | Z |
V | O | B |
Could you please help me.
Thanks a lot,
Almaz
Solved! Go to Solution.
Hi
= Table.FromRows(
List.Split(YourSource[Value],3),
List.FirstN(YourSource[Name],3)
)
or
let
Source = YourSource,
Group = Table.Group(Source, {"Name"}, {{"Values", each [Value], type list}}),
Table = Table.FromColumns(Group[Values],Group[Name])
in
Table
Stéphane
Hi
= Table.FromRows(
List.Split(YourSource[Value],3),
List.FirstN(YourSource[Name],3)
)
or
let
Source = YourSource,
Group = Table.Group(Source, {"Name"}, {{"Values", each [Value], type list}}),
Table = Table.FromColumns(Group[Values],Group[Name])
in
Table
Stéphane
Hi, Stepane.
let
Source = YourSource,
Group = Table.Group(Source, {"Name"}, {{"Values", each [Value], type list}}),
Table = Table.FromColumns(Group[Values],Group[Name])
in
Table
Thank you, this option works greate on test excel file, but when i want to do same on CVS/TXT file, it is doesn't work. Also, as i see there are two options how steps in query marks. When i work with CVS/TXT steps starts #.
If you are importing from a CSV, did you remember to promote the headers? (Use First Row as Headers)
I fix issue with CSV, Thanks Stepane!!!