Convert items to column

items are being displayed as row

how could it be being converted to be displayed as a column like the example below?
itens2

Hi @Rodrigo_Barbosa, it seems currently, your field novodado is currently an array and you would like to use the first value of that array as the key (or column header if you like) and the second value as the actual value and in the process aggregate multiple incoming items into a single output items.

I don’t recognise your data structure, but I suspect the fields and number of incoming items can change (as in your screenshots you have different fields for input and output data)? If so, my suggestion would be to write a custom transformation logic using the Function node taking all of this into account. It could look like so:

Input:

Output:

1 Like

thank you so much, that’s exactly what I needed.

1 Like

@MutedJam I have a question, would it be possible to remove the empty items?