Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, .....
You must do like
SubField(col2, '|') as col2
You must do like
SubField(col2, '|') as col2
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 🙂