topic Re: tfileinputpositional component trim all option not working in Talend Studio

tfileinputpositional component trim all option not working

Sudhee_Maximus — Sat, 16 Nov 2024 04:25:22 GMT

Hi Guys,

I am facing issue in reading loading the file to mysql as my source tfileinputPositional is not trimming columns as expected . please find attached files and suggest a solution.this record shouldn't have loaded to target as i have restricted null in col1 2 ,col3 etc ...this is how file looks in notepad++ with view show all charsview

please help ...

Re: tfileinputpositional component trim all option not working

TRF — Thu, 10 Oct 2019 14:36:41 GMT

Is "Trim all columns" option ticked on Advanced settings for the tFileInputPositional component?

Re: tfileinputpositional component trim all option not working

Sudhee_Maximus — Thu, 10 Oct 2019 15:18:00 GMT

yes please find below screenshot, also if I am using tSchemaComplianceCheck it is able to recognize the null/white spaces cols ... this looks weird to me.

Re: tfileinputpositional component trim all option not working

Anonymous — Thu, 10 Oct 2019 22:14:51 GMT

Hi,

I did a quick job execution using below data and Talend job spec.

The input component is trimming the data to empty string instead of null. There are two schools of thought here. In the case of positional files, the data can be considered as an empty string or data can be considered as null. My personal opinion is that it should be considered as null.

At the same time, the component is currently considering it as empty string and is sending to downstream component to make a choice by the user (like in tMap in my example). If you think that it should be null, could you please create a JIRA ticket so that we can get the view of Product team in this matter?

https://jira.talendforge.org

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tfileinputpositional component trim all option not working

Sudhee_Maximus — Fri, 11 Oct 2019 08:35:06 GMT

that helped me a lot nikhilthampi ....

here is the Jira raised by me TDI-43054.

Regards,

sudhee.reddy

Re: tfileinputpositional component trim all option not working

Sudhee_Maximus — Fri, 11 Oct 2019 08:53:00 GMT

I have one more followup ? on this , if I am using tSchemaCompliance check this record (with blank column) is going into reject record instead of inserting (that is what is expected).I am presently using the below to load the target ... please let me know if this is the better way or handling empty string in tmap is better ?

Re: tfileinputpositional component trim all option not working

Anonymous — Fri, 11 Oct 2019 14:10:01 GMT

Hi Sudheer,

This should be fine in your use case since the intention is to verify whether there is any problem in schema and the tSchemComplianceCheck is the right component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved