I’m having difficult accessing and merging data from a Postgres and previous node when the Postgres node returning less data in the array duo to 0 row is completed ignore in the output.
Node1: Read data from Google Sheets. returning 100 data.
Node2: Select data from Postgres but only found 90. (10 of them has 0 row so its ignore in the output)
Node3: Trying to merge data from Node1 and Node2 respectively.
Even if I enable
Always Output Data on Postgres node. still returning 90 in the array. The index 0 of the Postgres does not match the index 0 from Node1.
any comments or suggestions would be greatly appreciated. thank you