Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Please help me on below example in script level.
Source Table -
ID HandlingCode
1 FRO,PER,PHC
2 PES,PHC
3 ICE,PER
4 PER
5 EAP,PER
OutPut Table
ID HandlingCode1 HandlingCode2 HandlingCode3
1 FRO PER PHC
2 PES PHC
3 ICE PER
4 PER
5 EAP PER FRO
Use resident table and create fields like this,
Load
subfield(HandlingCode, ',', 1) as HandlingCode1, subfield(HandlingCode, ',', 2) as HandlingCode2,
subfield(HandlingCode, ',', 3) as HandlingCode3 .
.
Use resident table and create fields like this,
Load
subfield(HandlingCode, ',', 1) as HandlingCode1, subfield(HandlingCode, ',', 2) as HandlingCode2,
subfield(HandlingCode, ',', 3) as HandlingCode3 .
.
Thank You @raman_rastogi
Can we have any other way. ?
Due to Low performance . I already implemented on my Script but its take bit more time to execute.
Here in my script I used to do for 9 handling code Fields.
Sql Server. But here I need to do it in script level. Now I am using these script only, which you provided earlier.