Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pavithra52
Contributor
Contributor

How to extract key value pairs using tExtractJsonFields

Hi,

I have data in HBase. While retrieving data, In one table , a column contains

key value pairs The key value pairs are like :

{'id': '60946a0a', 'first_name': 'fred', 'last_name': 'tyler', 'email': 'admin@abc.com', 'name': 'fred tyler'}  

{'id': '413d67', 'first_name': 'jackson', 'last_name': 'roy', 'email': 'admin@def.com', 'name': 'jackson roy'}  

{'name': 'john abraham', 'first_name': 'john', 'last_name': 'abraham', 'id': '8b41f9i8', 'email': 'admin@ghicom'} 

{'id': '60946', 'first_name': 'george', 'last_name': 'paul', 'email': 'admin@jkl.com', 'name': 'john paul'}  

 

 

I want to retrieve this as separate columns :

 

name, first_name, last_name, id, email

 

'name' 'first_name' 'last_name' 'id' 'email'

fred tyler fred tyler 60946a0a admin@abc.com

jackson roy jackson roy 413d67 admin@def.com

john abraham john abraham 8b41f9i8 admin@ghi.com

george paul george paul 60946 admin@jkl.com

Does anyone have idea on how to achieve this?

Thanks in advance !

Labels (4)
1 Solution

Accepted Solutions
evansdar
Contributor II
Contributor II

This should get you what you're looking for

0693p000008vZgLAAU.png0693p000008vZpRAAU.png

View solution in original post

2 Replies
evansdar
Contributor II
Contributor II

This should get you what you're looking for

0693p000008vZgLAAU.png0693p000008vZpRAAU.png

Pavithra52
Contributor
Contributor
Author

@Daniel Evans​ Thank you so much 😊