SpreadsheetFile rearrange result

herrT15 · December 19, 2023, 9:48am

Hi,

Just one question on the spreadsheet node.
Is there a way to increase the quality of the way the results are shown or it depenses of the json?
For exemple :

It would be better to have something like

Thanks a lot

n8n · December 19, 2023, 9:48am

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:

ihortom · December 20, 2023, 3:14am

@herrT15 , to get the output depicted in the 2nd image the output in the node that feeds the data into the Spreadsheet node should look like this

[
  {
    "IP": "...",
    "continentCode": "...",
    "continentName": "...",
    "countryCode": "...",
    "countryName": "..."
  },
  {
    "IP": "...",
    "continentCode": "...",
    "continentName": "...",
    "countryCode": "...",
    "countryName": "..."
  }
]

Each property name represents the column, and each item in the array is a spreadsheet row.

herrT15 · December 20, 2023, 10:34am

Thanks. My json looks like
[

{

“8.8.8.8”:{

“continentCode”:“NA”,

“continentName”:“North America”,

“countryCode”:“US”,

“countryName”:“United States”,

“stateProvCode”:“CA”,

“stateProv”:“California”,

“city”:“Mountain View”

},

“1.2.3.4”:{

“continentCode”:“OC”,

“continentName”:“Oceania”,

“countryCode”:“AU”,

“countryName”:“Australia”,

“stateProvCode”:“QLD”,

“stateProv”:“Queensland”,

“city”:“South Brisbane”

},

“4.3.2.1”:{