Split JSON with different array

[pelucapampa]

Hi

I’m creating my first n8n workflow to extract data from HTTP request.

When i obtain data from api, i’ve this JSON

I need to tabulate this fields

NPS
detractors.count
detractors.percentage
promoters.count
promoters.percentege
passive.count
passive.percentage
total_answers

Could we help me, I tried to Split qualifications, but i’ve error.

[MutedJam]

Hi @pelucapampa, welcome to the community!

What do you mean by tabulate, do you simply need a file in which your values are separated by tabs?

I reckon you could first create a CSV in n8n, then replace all occurrences of the comma , with a tab character \t to create a TSV file like so:

The TSV file created by the final node works fine in LibreOffice Calc:

If you just need the string but not the file you could simply remove the last node.