How to get all the values of a column?

Hello Guys, how can I get all the rows values and organize them in a line like the text in yellow.

Information on your n8n setup

  • n8n version: 1.11.2
  • *Database: SQLite:
  • n8n EXECUTIONS_PROCESS setting default: own, main:
  • Running n8n via Docker

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:

That is sadly a little bit more complex as you try to access data across different items. So you want to probably do something like this:

{{ $input.all().map(item => item.json["sistema_id_tramitacao"]).join(',') }}

Be however aware that n8n runs by default all nodes once for all items. Meaning it would then execute the same query with two items also two times. So what you probably want to do is to go into the Node Settings (can be accessed via the cog-icon on the top right) and enable “Execute Once”.

Thanks a lot!

It works well!

image

Great to hear. Have fun!

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