Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Split columns and sort outcome?

Hi all, I'm trying to separate a column which has an array of key/values in it, and the keys are not always: ColumnTags {"App: App1","Build: Build1", "Environment: Dev","Run Time: 24x7"} {"App: A...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous 

     

    first remove the curly braces

    Add a Index (id)

    Split Column by Comma into Rows (One Row for each Key:Value pair)

    Split Column by Colon (Split Key:Value pair)

    Pivot Column "Column1.1" -> Value Column "Column1.2" -> Don't Aggregate

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for the help.

Could you help me understand your Query so I know what to replace where and what am I doing?

Thanks again

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Anonymous 

 

first remove the curly braces

Add a Index (id)

Split Column by Comma into Rows (One Row for each Key:Value pair)

Split Column by Colon (Split Key:Value pair)

Pivot Column "Column1.1" -> Value Column "Column1.2" -> Don't Aggregate

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.