Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel file which contains ID and other fields. ID contains multiple values in it. I need to separate each row based on ID.
Example:
ID Value
1,2,3 100
4,5,6 200
7,8,9 300
Output:
ID Value
1 100
2 100
3 100
4 200
5 200
6 200
7 300
8 300
9 300
Can any one tell me a way to achieve this.
Thanks
Try using the Subfield() function:
Table:
LOAD * Inline [
ID | Value
1,2,3 | 100
4,5,6 | 200
7,8,9 | 300
] (delimiter is |);
NewTable:
NoConcatenate
LOAD SubField(ID, ',') as ID,
Value
Resident Table;
DROP Table Table;
Update1: Forgot to add NoConcatenate
Update2: Sample Attached
Try using the Subfield() function:
Table:
LOAD * Inline [
ID | Value
1,2,3 | 100
4,5,6 | 200
7,8,9 | 300
] (delimiter is |);
NewTable:
NoConcatenate
LOAD SubField(ID, ',') as ID,
Value
Resident Table;
DROP Table Table;
Update1: Forgot to add NoConcatenate
Update2: Sample Attached
Thank you. It's working the way I need.
Awesome
I am glad I was able to help.
Best,
Sunny