I am facing an issue. I want to save file .csv extension but not the columns separated with delimiter. I want every column to be in different cell.
But, using tFileDelimited component, I am getting as
I know, this is possible by creating excel file, but I want csv file.
Is there any solution?
Solved! Go to Solution.
A cell is not plain text csv. Do you mean to output to Excel (tFileOutputExcel) or do you mean outputting a readable format like with tFileOutputPositional?
Choosing comma as delimeter solved my problem. But, if the input data column has comma in it, it is treating as seperate data. I mean if the data is like ABC, DEF which is a single string is treated as two different columns.
Can I get solution to this?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.