Delimited String to List

Highlighted
One Star

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

Community Manager

Re: Delimited String to List

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

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now