Best approach for multiple unrelated data streams

Questions
1

Hi Everyone,

I’m sorry if this is a common question; maybe I’m just not asking correctly. Here’s what I’m trying to accomplish:

  1. I have one path that will search in OneDrive and get my Excel file and ID of Sheet needed.
  2. I have another path that will hit a HTTP request for details on IoT devices
  3. I want write to an Excel node using the details from path 1 and the data from path 2.

I saw some details on ‘Multiplex’ mode in the Merge that it is no longer supported.

It seems weird to me to merge everything into one massive table, but is that the way using Append? That means I’d have to write the same value 100’s of times into a table and pick the first one (I’m guessing)?

My hope was that there is some sort of variable I can write to that would get called later / is available?

Running the latest stable 1.77.3 cloud version.

Thanks in advance!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

I finally got it. After a merge, if you want to access data from a node before the merge you have to write it like this:

{{ $node[“NODENAME”].data.thingyouwant }}

Now I can pass all my data from the HTTP into a merge to make it wait for everything to be ready. I tell the merge to only use data from that input. On my Excel node I can use the other nodes before that merge with the code above.

4

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