Forum Discussion
Need alternative data types for Multivalued and Array data type
Hi Team, I need to import data from SAP to Fabric using Fabric. where some columns datatype is Array type and some tcolumns data type is Multivalued. instead of Array and Multivalued, which data ty...
Hi,
I don't have this specific experience, but tables in Fabric will not support arrays or multivalued columns. You may need to make a first import of the data as JSON, which supports this, and later transform the JSON in a flat model which fits your needs.
The flat model may result in more than a single table, creating a relationship between the main record and each related information on the multivalued columns.
Kind Regards,
Dennes