Forum Discussion

dommyw277's avatar
dommyw277
Helper V
8 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.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
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.

  • dommyw277's avatar
    dommyw277
    Helper V
    8 months ago

    Amazing thank you, Merry Christmas!  🙂