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.
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.