Forum Discussion

Mohanraj87's avatar
Mohanraj87
Frequent Visitor
2 years ago
Solved

Dynamically removing columns ending with even numbers

Hi All,   In Power Query, I have split a column based on "," delimiter and the result produced one column split into 10 columns and columns names have been named as "Column_1", "Column_2", and till...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi

    With 10 columns

    = Table.SplitColumn(#"Changed Type 1", "Details", each List.Alternate(Text.Split(_,","),1,1,1), 10)

     or

     

    = Table.SplitColumn(
          #"Changed Type 1",
          "Details",
          each List.Alternate(Text.Split(_,","),1,1,1), 
          List.Max(
               Table.TransformColumns(
                     #"Changed Type 1",
                     {{"Details", each Number.IntegerDivide(Text.Length(Text.Select(_,",")) + 1, 2) + 1, Int64.Type}}
                     )[Details]
           )
    )

     

    https://goodly.co.in/split-by-variable-columns-in-power-query/

     

    Stéphane

slorin's avatar
slorin
Super User
2 years ago

Hi

 

= Table.SplitColumn(Your_Source, "Your_Column", each List.Alternate(Text.Split(_,","),1,1,1))

Stéphane 

Mohanraj87's avatar
Mohanraj87
Frequent Visitor
2 years ago

Hi slorin ,

 

Below is the screenshot of my Power Query and Advance editor. In the post I have mentioned the column name having "_", but in reality its ".". So, I tried to replace "_" to "." in the advance editor, but it didnt work. 
Let me know as what is wrong.