Convert to file header issue with csv

Questions
1

Describe the problem/error/question

I build a flow which fetches a csv file from my ftp. It then translates the file with a http request to DeepL. After the values in the columns has been translated, the file is being converted back to csv and then uploaded to a ftp again. The flow works so far.

The issue I am facing now is, that I lose the file structure from the original file. The header row changes, the columns have different names and some columns are added. My aim is to keep the structure and the header row as it is in the original input file.

How can I do this?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

hello @hair2heart

That depends on how the deepl returns the data. Most probable, you will need to add some identifiers to column names, so it will be possible to determine which translation to which column belongs to.

3

Hello @barn4k , thank you for your reply. Can you give me a solution that works? Based on your answer I can not fix the issue I am facing.

4

I can’t help you with it, as I’m not aware of the deepl or the file structure you are using there

5

@barn4k so what do you need in order to find a solution?

6

The question has not been solved. Still struggling to find a solution.

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.