Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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