Column Name to Item

Questions
#1

Hey i need to transform the column name to own items.

here is a json
can some show me how that works?
Thank you!

[
{
"MHM Design Matthias Heidrich-Wolf": 1,
"MICON UG (haftungsbeschränkt) Bildung & Beratung": 2,
"Möbel Karmann GmbH & Co.KG Möbelhandel": 1,
"Schüller Möbelwerk": 1,
"Schüller Möbelwerk KG": 1,
"Unternehmensgruppe Groth GmbH": 1,
"Wohnorama Möbel Kuch GmbH Gaimershei": 1
}
]

Screenshot 2022-09-13 150146
Screenshot 2022-09-13 1501461064×88 6.96 KB

#2

Hey @Benedikt_Bohm,

I am not sure I understand what you mean, What are you trying to display?

#3

Hey,

i want that the columns are in their own lines, that i can process every column as a own item.

#4

So you would get a column named “Key” And a column named “Value” for example?

#5

yes correct!

#6

Want that every Json line in counts returns as one item.

#7

What you would need to do is something like this:

For some reason I cannot login to my test environment at the moment. So Cannot create you a sample.

#8

Thank you, but it doesnt work…

ERROR: The json-property has to be an object! [Line 109]
NodeOperationError: The json-property has to be an object!

#9
#10

Thank you verry much!!

1 Like