How to extract required values from a text

[viveksasi94]

Hi everyone,

I have a dataset in which one column is in text data type. I need to extract the Intent and its corresponding score from each row.

Please take a look at the sample dataset.

Input

Required Output

Thanks in advance 🙂

[v-cherch-msft · Accepted solution]

Hi @viveksasi94

You may try to use 'split column' and 'pivot column' in query editor. Attached the sample file for your reference.

Regards,

Cherie

[viveksasi94]

Thanks for your suggestion, but splitting the columns is not working for me as the order of intents may change. This leads to adding other intents also into the column. For example in the 1st row it starts with Admin, but in second row it started with PTO.