Error loading a table

[Anonymous]

how you can load a column with double quote in csv file using talend job . I am getting one error while loading one table. For example, let's say csv file contain below record separated by | delimiter.

1234|test " quote|field 3|167

Can you test loading this one and tell me what options you used ?

[Anonymous]

Hi,

    You will have to use the standard options available in tfileinputdelimited component. I was able to read it properly and print the same.

Job flow

Component details

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi Nikhil,

Thank you for your response how did you get the output to print the actual table?

[Anonymous]

Hi,

    I have used tlogrow to print it to console. In the tlogrow, there is an option to show it as table.

    If you are trying to load the data to DB, you need to mark the target column as String and it will be populated automatically. If you are facing any issue in data load part, could you please share the screenshot of the tDBOutput component along with your schema definition?

    I don't think DB layer will obstruct this task. 

Warm Regards,

Nikhil Thampi

[Anonymous · Accepted solution]

@etole006, I hope I have answered your original query.

Could you please mark the topic as resolved with the post which has answer as right solution so that it will enrich the Talend community and will help fellow community members in future?

Warm Regards,

Nikhil Thampi