Cinchoo/ChoETL

Help!

Haniamin90 opened this issue · 1 comments

Haniamin90 commented

im having a hard time parsing this json into CSV, the output should be:

the random_number could be anything.

header: id; t; tn; tid....
values: random_number; t; tn; tid......
image

please help, thanks

{
  "random_number": {
    "t": 100800,
    "tn": 1671933005,
    "tid": "279",
    "txzone": "Asia/Tbilisi",
    "sth": "450228",
    "stv": "203986",
    "slu": "1587888024",
    "slht": "1656684260",
    "iu": "test",
    "iti": "testtest",
    "ide": "..",
    "ish": "0",
    "isv": "0",
    "it": "0",
    "ic": "23",
    "isp": "1",
    "il": "0",
    "idi": "1587888024",
    "ilu": "1587888024",
    "tod_h": 0,
    "tod_v": 0,
    "cur_online": 0,
    "tot_v": "203986",
    "tot_h": "450228",
    "last_hits": "1656684260"
  },
  "random_number": {
    "t": 3343566,
    "tn": 4444456,
    "tid": "279",
    "txzone": "Asia/Tbilisi",
    "sth": "453456",
    "stv": "664",
    "slu": "1587888024",
    "slht": "1656684260",
    "iu": "test",
    "iti": "testtest",
    "ide": "..",
    "ish": "0",
    "isv": "0",
    "it": "0",
    "ic": "23",
    "isp": "1",
    "il": "0",
    "idi": "1587888024",
    "ilu": "1587888024",
    "tod_h": 0,
    "tod_v": 0,
    "cur_online": 0,
    "tot_v": "203986",
    "tot_h": "450228",
    "last_hits": "1656684260"
  },
  ....more...
}
Cinchoo commented

Here is sample fiddle shows how to achieve it

https://dotnetfiddle.net/9uBlUv