How to convert Key value pairs into separate columns

[Pavithra52]

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.

[manodwhb]

@Pavithra52 , you need to use tExtractJsonFields.

check the below link to know more about it.

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