Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Mederic
Helper V
Helper V

Fill a column with identical labels

Hello everyone,
I have a column with a number of nested data that repeat every 5 values
How do I get a column with label names? (see screenshot)

Thanks in advance

Best Regards

 

Input
James
M
A213
19/05/1994
London
Maria
F
B623
28/06/1974
Paris
Anthony
M
A931
21/09/1983
Berlin

 

FillDown.jpg

 

1 ACCEPTED SOLUTION
ronrsnfld
Super User
Super User

Here's one way:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMTS1WitWJVvIFk45GhsZghqGlvoGpvqGlpQmY65Ofl5KfB1GYWJSZCGa5gUknMyOIFiMLfQMzoBZziJYAoDqI0Y55JRn5eZXI1lgaG0L0GOobWAL1WECMcEotyskEWhMLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Input = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Input", type text}}),

    Labels = {"Name","Gender","ID","Birth","City"},
    #"Label Column" = List.Repeat(Labels,Table.RowCount(#"Changed Type")/5),

    #"Add Label Column" = Table.FromColumns(
        Table.ToColumns(#"Changed Type") & 
        {#"Label Column"}, Table.ColumnNames(#"Changed Type") & {"Result"}),

    #"Changed Type1" = Table.TransformColumnTypes(#"Add Label Column",{{"Result", type text}})
in
    #"Changed Type1"

ronrsnfld_0-1696110012374.png

 

 

View solution in original post

2 REPLIES 2
Mederic
Helper V
Helper V

Hello @ronrsnfld ,

Thank you very much, it worked perfectly as always 🙂
Have a nice day

ronrsnfld
Super User
Super User

Here's one way:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMTS1WitWJVvIFk45GhsZghqGlvoGpvqGlpQmY65Ofl5KfB1GYWJSZCGa5gUknMyOIFiMLfQMzoBZziJYAoDqI0Y55JRn5eZXI1lgaG0L0GOobWAL1WECMcEotyskEWhMLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Input = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Input", type text}}),

    Labels = {"Name","Gender","ID","Birth","City"},
    #"Label Column" = List.Repeat(Labels,Table.RowCount(#"Changed Type")/5),

    #"Add Label Column" = Table.FromColumns(
        Table.ToColumns(#"Changed Type") & 
        {#"Label Column"}, Table.ColumnNames(#"Changed Type") & {"Result"}),

    #"Changed Type1" = Table.TransformColumnTypes(#"Add Label Column",{{"Result", type text}})
in
    #"Changed Type1"

ronrsnfld_0-1696110012374.png

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors