Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
nrao1693561508
Contributor II
Contributor II

unable to load Json data into csv file

I am reading JSON File and loading into csv file , but data is not coming as per the json file data

please some one help out.

it is one -one load, and datatype is sting only

0695b00000nSe5iAAC.png

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

I guess it is a display issue, open the CSV file using notepad++ and see if the data is the same as JSON.

View solution in original post

4 Replies
Anonymous
Not applicable

Hi

Can you please show us an example of your JSON data? and what are your expected output result?

 

Regards

Shong

nrao1693561508
Contributor II
Contributor II
Author

Hi Shong

 

0695b00000nSqZ5AAK.png 

This is data coming from json where datatype is string and it is one-one load.

Reading from JSON and loading into csv file as same as JSON.

In tlogrow have loaded , data is coming as JSON only.

But

when load into csv file format data is changing like below

0695b00000nSqacAAC.png

Anonymous
Not applicable

I guess it is a display issue, open the CSV file using notepad++ and see if the data is the same as JSON.

nrao1693561508
Contributor II
Contributor II
Author

Hi Shong,

 

Many thanks for the update, data is loading in notepad++ as per JSON FILE.