Subfield N times

[BTIZAG_OA]

Hello there, 

i have a data like this seperated with '|'

col1,col2

val1,random1|random2|random3....

val2, .....

how can i change this to 

col1,col2

val1,random1

val1,random2

val1,random3

val2, .....

i tried something with subfield but i have something like this

col1,col2,subfield1,subfield2,subfield3,...

val1,random1,null,null,...

val1,null,random2,null,...

val1,null,null,random3,...

val2, .....

[Anil_Babu_Samineni · Accepted solution]

You must do like

SubField(col2, '|') as col2

[BTIZAG_OA]

Hello Anil_babu_samineni

Thanks a lot, i double check the syntax of subfield func. i didnt noticed this

"If you use the Subfield() function in a LOAD statement with the optional field_no parameter left out, one full record will be generated for each substring"

have a nice day 🙂