Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2019-07-25 02:35 PM

Need help with Metadata and seperating fields

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!

 

0683p000009M6Mc.png0683p000009M6Mh.png

Labels (2)
Labels
192 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-07-26 04:51 PM
Author

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 🙂

192 Views
0 Likes