Matillion Extract_Nested_Data component is not able to flatten data for nested array

Matillion ETL
1

Please find Input file attached in the thread.

Schema for the table:

0694G00000KqYNFQA3_0D54G00008QtJ4ISAV
0694G00000KqYNFQA3_0D54G00008QtJ4ISAV988×603 24.1 KB

While trying to flatten the array data using the Extract_Nested_Data component within the dictonary(STRUCT) it is showing below error

0694G00000KqYN0QAN_0D54G00008QtJ4ISAV
0694G00000KqYN0QAN_0D54G00008QtJ4ISAV990×283 22.6 KB

This is the column structure while flattening the data.

0694G00000KqYM7QAN_0D54G00008QtJ4ISAV
0694G00000KqYM7QAN_0D54G00008QtJ4ISAV348×540 19.5 KB

2

Resolved:

When we tried to flatten the data from the array dataset using Extract_Nested_Data its parent node key should be in all lowercase. Like in the above case CustomerMasterData has an array data structure so here when I changed CustomerMasterData to customermasterdata it worked fine.

3

Hi @abhishek.tidke​

It's great you were able to work out a solution. I appreciate you sharing this update with the Community.

Cheers!

Chika