Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
model | weight |
a-1 | 1 |
a | 5 |
a-2 | 4 |
b | 3 |
b-1 | 3 |
b-2 | 2 |
I want to convert the above to below using wildmatch or subfiled function.
model | weight |
a | 1 |
a | 5 |
a | 4 |
b | 3 |
b | 3 |
b | 2 |
Please help me. thank you.
HI
Try like below
Load SubField(model,'-',1) as model, weight Inline
[
model weight
a-1 1
a 5
a-2 4
b 3
b-1 3
b-2 2
](delimiter is ' ');
HI
Try like below
Load SubField(model,'-',1) as model, weight Inline
[
model weight
a-1 1
a 5
a-2 4
b 3
b-1 3
b-2 2
](delimiter is ' ');
@PARK_JY Please use the below code:
NoConcatenate
Temp:
Load SubField(model,'-',1) as model,
weight
inline [
model, weight
a-1, 1
a, 5
a-2, 4
b, 3
b-1, 3
b-2, 2
];
Exit Script;
Please like and accept it as a solution if it resolves your issue.