Possible to create 2 tables in a single csv file?

[rochajulian]

I'd like to have one table for user account data such as email, name, etc and a SEPARATE table for their todo data such as task name, due date, etc. is this possible with this library? docs dont say so I thought to ask. This would be nice to have for sure.

[oliverfoster]

No.

This library, json2csv, is for changing the format of some data from json into csv.

source json

[
  {
    "email": "yes@yes.com",
    "name": "yes"
  },
  {
    "email": "no@no.com",
    "name": "no"
  }
]

destination csv

email,name
yes@yes.com,yes
no@no.com,no

You haven't said why you want to have multiple tables in one csv.

As an illustration, I'm going to imagine you want to open the csv in Excel as a sheet, and that you want two tables to appear on the one sheet.

You would have to take your user account json data and use json2csv convert it to csv:

user account json data

[
  {
    "email": "yes@yes.com",
    "name": "yes"
  },
  {
    "email": "no@no.com",
    "name": "no"
  }
]

user account csv data

email,name
yes@yes.com,yes
no@no.com,no

Then you would take your todo task json data and use json2csv to convert that to csv:

todo task json data

[
  {
    "task": "drive home",
    "date": "01/01/1979"
  },
  {
    "task": "quit job",
    "date": "02/01/1979"
  },
  {
    "task": "go on holiday",
    "date": "03/01/1979"
  }
]

todo task csv data

task,date
drive home,01/01/1979
quit job,02/01/1979
go on holiday,03/01/1979

Then you would need to write some code to make a larger csv, with an appropriate number of rows and columns and shift one table into the correct position:

combined into a double table csv

email, name,,,task,date
yes@yes.com,yes,,,drive home,01/01/1979
no@no.com,no,,,quit job,02/01/1979
,,,,go on holiday,03/01/1979

Opened in Excel, it would look like this:

a.csv