topic Re: Subfield N times in App Development

Subfield N times

BTIZAG_OA — Mon, 28 Dec 2020 14:54:17 GMT

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, .....

Re: Subfield N times

Anil_Babu_Samineni — Mon, 28 Dec 2020 14:59:00 GMT

You must do like

SubField(col2, '|') as col2

Re: Subfield N times

BTIZAG_OA — Tue, 29 Dec 2020 07:12:08 GMT

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 🙂