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
    7 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

Getting only errors at the moment. What parts do i need to add my info? Just the table part? 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 months ago

Give a name to the Table as Data.  Then the code will work.

  • dommyw277's avatar
    dommyw277
    Helper V
    8 months ago

    Renamed the table to Data as per your screenshot but still getting an error only in the column

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 months ago

      I really do not know what error you are committing.

      • V-yubandi-msft's avatar
        V-yubandi-msft
        Community Support
        8 months ago

        Hi dommyw277 ,

        We’re not sure yet what specific error you’re seeing after using the code provided by Ashish_Mathur 
        To help you more accurately, could you please share the exact error message or a screenshot of the error.

        This will make it much easier for us to identify the issue and guide you correctly.

         

        Ashish_Mathur , Thanks for your patience and for sharing the details so far.