Ask Your Question
1

how to flatten the json data

asked 2018-06-28 00:13:41 -0600

Maithri gravatar image

updated 2018-06-28 08:19:51 -0600

metadaddy gravatar image

Suppose i have data in the format:

{Data:{col1:value1,col2:value2,col3:value3}}

I want to get the data in the following format:

{col1:value1,col2:value2,col3:value3}

I want to eliminate the extra field Data.How to achieve this?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2018-06-28 04:27:06 -0600

Maithri gravatar image

updated 2018-06-28 08:20:05 -0600

metadaddy gravatar image

Used Field Flattener to flatten the data,then eliminated Data. using Field Renamer by specifying the pattern /'Data.(.*)' in the Source Field Expression and /$1in the Target Field Expression. Referred https://streamsets.com/documentation/...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-28 00:13:41 -0600

Seen: 217 times

Last updated: Jun 28