Skip to main content

Data Quality & Catalog βš™οΈ

Discuss, learn, ask, suggest, share all things DQ&C πŸ”

  • 803 Topics
  • 2,043 Replies
803 Topics
I have to write below Multi array list in to a file through JSON call.How can I perform this?

Json :Β [Β  Β {Β  Β  Β  "Headers":[Β  Β  Β  Β  Β "Empid",Β  Β  Β  Β  Β "Name",Β  Β  Β  Β  Β "dept",Β  Β  Β  Β  Β "EMAIL"Β  Β  Β  ],Β  Β  Β  "ID":"Table_112",Β  Β  Β  "Rows":[Β  Β  Β  Β  Β [Β  Β  Β  Β  Β  Β  "100",Β  Β  Β  Β  Β  Β  "John",Β  Β  Β  Β  Β  Β  "Finance",Β  Β  Β  Β  Β  Β  "John@gmail.com"Β  Β  Β  Β  Β ],Β  Β  Β  Β  Β [Β  Β  Β  Β  Β  Β  "101",Β  Β  Β  Β  Β  Β  "Smith",Β  Β  Β  Β  Β  Β  "HR",Β  Β  Β  Β  Β  Β  "Smith@gmail.com"Β  Β  Β  Β  Β ],Β  Β  Β  Β  Β [Β  Β  Β  Β  Β  Β  "102",Β  Β  Β  Β  Β  Β  "Derek",Β  Β  Β  Β  Β  Β  "Marketing",Β  Β  Β  Β  Β  Β  "Derek@gmail.com"Β  Β  Β  Β  Β ]Β  Β  Β  ]Β  Β }]Β Expecting the output in below format:Empid Name dept EMAIL ID 100 John Finance John@gmail.com Table_112 101 Smith HR Smith@gmail.com Β  102 Derek Marketing Derek@gmail.com Β  Β Β Β I have created a plan with below details:After running a plan with JSON CALL step below response file got created.Β Β Β Based on response file i have given below columns in Data StreamsΒ Β Β Β I am not getting the out put what i expected.Β Appreciate your help and support .Β 

Badge winners

  • First idea πŸ’‘
    sumithhas earned the badge First idea πŸ’‘
  • First idea πŸ’‘
    VanNguyenhas earned the badge First idea πŸ’‘
  • First idea πŸ’‘
    SusanShas earned the badge First idea πŸ’‘
  • 10 ideas πŸ’‘
    akumahas earned the badge 10 ideas πŸ’‘
  • First idea πŸ’‘
    romizhas earned the badge First idea πŸ’‘
Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, andΒ have an opportunity to shape the future of new products.

Read more