I'm using an Excel (all the data are String variables) trying to merge rows with replicated values. For example, if I have 5 rows with the word Monday i want Talend to merge this information in a single row setting the same text (I'm using tDenormalize for this). This is the job:
After executing job I get this error:
I would like to know why this error in the generated code appears. Thanks!
Solved! Go to Solution.
Thanks @akumar2301, that was the problem! 2 questions:
-If my Excel has null cells, how do i delete the default "null" value I get in the output?
-I read tDenormalize can change input order. Is there any component or way to order the data again like the original order?
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.