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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Pavithra52
Contributor
Contributor

How to convert Key value pairs into separate columns

I have HBase table where one column consists of key value pairs, I want that key value pairs as separate columns(Based on Keys). 

 

example :

 

INPUT :

Alert_type(Column name) :

{'name': 'xxx', 'id' : '05'}

{'name': 'yyy', 'id' : '06'}

 

OUTPUT:

name  id

xxx     05

yyy    06

 

Please kindly help me with this.

 

Thanks in advance.

 

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

@Pavithra52 , you need to use tExtractJsonFields.

 

check the below link to know more about it.

 

https://help.talend.com/reader/WfrS1ZaBst3az8zJBGoMSQ/9l0VIDZiqZLVUc0fDdvBrA