Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Reorder column values

I have a two column table. One of the columns has Employee Id and the other has a list of all the benefits that the employee holds. I want to split by delimiter, a comma, but have the columns sort by...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    I made a simplified dataset.

    First, split the Benefits column by comma delimiter into rows

    Split the resulting Benefits column into columns by forward slash delimiter to get...

    I trimmed Benefits.1 and also replaced the null values in Benefits.2 with 'Has'

    Then Pivot Column Benefits.1 using values from Benefits.2 without aggregating

    To end up with...

    Hope this gets you pointed in the right direction.

jgeddes's avatar
jgeddes
Super User
3 years ago

I made a simplified dataset.

First, split the Benefits column by comma delimiter into rows

Split the resulting Benefits column into columns by forward slash delimiter to get...

I trimmed Benefits.1 and also replaced the null values in Benefits.2 with 'Has'

Then Pivot Column Benefits.1 using values from Benefits.2 without aggregating

To end up with...

Hope this gets you pointed in the right direction.