Describe the problem/error/question
I want to edit a csv that I get locally and convert to json during the workflow, then the if commands seperates 5 rows with the emty colum to pass on to gemini, gemini searches for the domain and passes it on with the ID included. Now in the merge node I grab the json I got in the very beginning and merge it with Combine > Matching Fields > ID > Enrich input 2 (because 2 is the json from the beginning, and 1 is the json with just an ID and Domain). The node runs successfully but when i go to check ID’s that got a domain provieded they are still [empty] and I don’t see any reason why.
What is the error message (if any)?
None
Please share your workflow
Share the output returned by the last node
Output: 25 Bürgschaftsbank Rheinland-Pfalz GmbH [empty] [email protected] … More info here
Expected: 25 Bürgschaftsbank Rheinland-Pfalz GmbH www.bb-rlp.de [email protected] … More info here

Here are my inputs, Input 2 starts with ID 1 but since it already has a domain it was skipped in my workflow and we start at 25 as seen in input 1 ID.
Information on your n8n setup
- n8n version:1.98.2
- Database (default: SQLite):SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main):own, main
- Running n8n via (Docker, npm, n8n cloud, desktop app):CMD with n8n start
- Operating system: Windows 11
Please can you add your workflow json inside of a code block

Yes, sorry I did not know how. Updated now
I think the merge will only work here if you had two lists you want to merge. But looking at your workflow, you currently have 1 file and one result. So Maybe try merging this by position instead. What is the reason you want to do the merge because It might not be necessary
Well basically I have a pretty big list but sometimes a name or an email or whatever is missing. I want to automate the process of identifying emty cells, sorting by them, then pass them on to gemini to find out whatever is needed > then add the new data to the list.
I belive I have two lists because I take some data from the IF node and let gemini create text with the ID and whatever is needed, then convert it to json with the code block to then combine the new json with the old table.
But no matter what, it will not link it based on the ID, best I can do is to just add it to the top, so I know it gets usable data but adding outside the correct lines defeats the whole purpose.
Are you able to provide us with an example file you use. It’s difficult to see whats actually happening without running the workflows with data
I mocked something up, the fields go on for a while longer including an ID field to identify it. I am not allowed to upload anything other than pictrues.
I’m also open to alternative solutions if there are any ideas, as long as the data is added to the existing data in the end its good for me…