Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Knowme
Contributor
Contributor
‎2021-04-26 11:33 AM

Json data extraction from a log file

Hi,

I have a .log file which is having json script in the middle of some text data. I need to parse the json data from this and load into database. I tried tJsonInput but its not working. Any suggestions?

Thank you

Labels (4)
134 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2021-04-27 01:30 AM

Hello,

TalendHelpCenter: tExtractJsonFields component is used to extract data from a Json string.

Let us know if it is what you are looking for.

Best regards

Sabrina

134 Views
0 Likes
Knowme
Contributor
Contributor
‎2021-05-04 03:38 PM
Author

In response to Anonymous

I tried that but since the format and text fields are not consistent its not getting the right schema.

134 Views
0 Likes
gjeremy1617088143
Master
Master
‎2021-05-05 03:53 AM

In response to Knowme

Hi, you need to extract first the json from the rest of the text then you can use tExtractJsonFields to parse json data.

Could you send us an example of the log file content ?

134 Views
0 Likes