The data can't be filled in Extract Nested Data

Matillion ETL
1

I need to unstack a column having JSON format data and I am using Extract Nested Data component. However, in the Data Structure property, the data is not auto filled. I am not sure why, can anyone help with this or other suggestion to parse the JSON column.

0694G00000HeumVQAR_0D54G000087UMUGSA4
0694G00000HeumVQAR_0D54G000087UMUGSA41061×766 48.8 KB

2

The "Extract Nested Data" Component has to be connected to another Component that provides a JSON attribute in its output values. Please share a screenshot of the incoming connection to your "Extract Nested Data" Component as well as the data types of the previous component.

3

Hi Michael,

 

Thank you so much.

The data is coming from an 'Input Table' component and the JSON column is VARCHAR, so I used 'Construct Variant' component on the JSON column and now it works.

0694G00000IGw14QAD_0D74G000007kJjPSAU
0694G00000IGw14QAD_0D74G000007kJjPSAU735×183 12.7 KB

 

Thanks once again.

Merry Christmas and Happy New Year