tfileinputpositional component trim all option not working

[Sudhee_Maximus]

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 ...

[TRF]

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

[Sudhee_Maximus]

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. 

[Anonymous]

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

[Sudhee_Maximus]

that helped me a lot nikhilthampi ....

here is the Jira raised by me TDI-43054.

Regards,

sudhee.reddy

[Sudhee_Maximus]

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 ?

[Anonymous]

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