Need help with Metadata and seperating fields

Anonymous — Thu, 25 Jul 2019 18:35:23 GMT

Hello Talend Community!

I need your help! Below in the first screenshot you will see my CSV file. I am convinced it has the proper spacing to separate each field. However, when I go to preview in the next screenshot... you will see that some of the fields get combined like PropertyIdWR. I'm not sure what to do to get the correct fields because right now it is shifting everything and putting the wrong fields with the wrong headers... anyways, please send your advice! Thanks!

Re: Need help with Metadata and seperating fields

Anonymous — Fri, 26 Jul 2019 20:51:48 GMT

Hi,

Could you please share a sample file with 5 records having this issue? Then we can try to replicate the issue in our environments.

A word of caution is that Space is not a great value to use as Column separator. The reason is that it can come as part of Column value also. So in this case, you should ideally have a text enclosure symbol (like double quotes) so that tools like Talend can identify that its indeed a separate column.

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 🙂

topic Need help with Metadata and seperating fields in Talend Studio

Need help with Metadata and seperating fields

Re: Need help with Metadata and seperating fields