Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Delimited String to List

Hi,

 

I am a newbie in Talend and I have an issue that I could use your help with. I am trying to convert a string delimited by '|' or pipe delimited to a list that I can write to a JSON file. The bigger issue is some rows have 2 values and some have one so it can either be a single element list or two element list.

 

I tried using tNormalize and tExtractDelimitedFields I keep running into this issue of the job complaining "Type mismatch: cannot convert from String to List" and goes on talking about the JVM.

 

Any help would be greatly appreciated.

 

Thanks

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi
Can you show us an example to explain your problem? and what are you expected result?

Regards
Shong