Forum Discussion
Helper IHow to extract required values from a text
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 :)
Hi viveksasi94
You may try to use 'split column' and 'pivot column' in query editor. Attached the sample file for your reference.
Regards,
Cherie
2 Replies
v-cherch-msftMicrosoft Employee
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.