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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to map the JSON file using TFileInputJSON

Hi All,

 

I'm unable to map the JSON file using tFileInputJSON and attached the sample file .

Can anyone advice me on this?

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

 

   I was able to do it by adding the file to Repository flow as shown below. In the repository, create JSON and select Input. The next stages are as shown below. First add the root path and after that map the columns.

0683p000009M5r8.png

 

0683p000009M5rD.png

 

I was able to print the data as shown below. Please note that I selected vertical mode in tLogrow to show the data easily. You can select normal or table mode too.

0683p000009M5rI.png

 

I hope you got the answer for your query. Please spare a second to mark the topic as resolved. Kudos will be a bonus 🙂

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

 

 

 

 

View solution in original post

2 Replies
fdenis
Master
Master

try to remove spaces.
check couples of {}
try to shrink it star wit a smaller one.
Anonymous
Not applicable
Author

Hi,

 

   I was able to do it by adding the file to Repository flow as shown below. In the repository, create JSON and select Input. The next stages are as shown below. First add the root path and after that map the columns.

0683p000009M5r8.png

 

0683p000009M5rD.png

 

I was able to print the data as shown below. Please note that I selected vertical mode in tLogrow to show the data easily. You can select normal or table mode too.

0683p000009M5rI.png

 

I hope you got the answer for your query. Please spare a second to mark the topic as resolved. Kudos will be a bonus 🙂

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂