Forum Discussion

dommyw277's avatar
dommyw277
Icon for Helper V rankHelper V
9 months ago
Solved

Splitting Column values

Hi, how would i split a column like this:   Category1 SR-01 SR-02 SR-03 Category 2 SR-05 INC-01 INC-02 Category 3 INC-03 SR-06 etc etc
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    8 months ago

    Hi dommyw277 ,

    Thanks for the screenshot  that really helps. As per my guess, the Invalid identifier error is coming from the way the column name Inc/SR is being referenced. Because the column name contains a slash (/), Power Query requires the #""  format.

    So anywhere you have- [Inc/SR]

    please change it to - [#"Inc/SR"]

    And in your filter step

    each [#"Inc/SR"] <> null and [#"Inc/SR"] <> ""

    Once the column is referenced with [#"...."] , the syntax error should be resolved.


    Hope this helps please give it a try. If anything still comes up, feel free to share another screenshot and we can take a look.

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
9 months ago

Hi, 

 

You'd need 3 major Power Query UI steps. For your sample data, first add a column, 

Fill down 'Custom' Column. 

Filter out 'Category' in Column1 

The rest would be renaming, reordering etc. 

 

Same logic for your new data dommyw277