How to load excels sheet with different schema into cosmos DB using ADF

Sivanesan S 21 Reputation points
2022-03-10T12:18:16.847+00:00

I am trying to load some excel files with same sheet name but with different schemas from Azure blob storage to Azure CosmosDB using ADF. I have created the pipeline using wildcard source path. But while trying to preview the data its throwing an error saying that load excel with different schema is not supported now
Can anyone suggest how to proceed further.

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,497 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,470 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,777 questions
{count} votes

Accepted answer
  1. Samy Abdul 3,366 Reputation points
    2022-03-10T13:35:25.393+00:00

    Hi @Sivanesan S , Generally, we use Lookup/ GetMetaData activity depending upon the requirement to read through the source and pass the output to ForEach activity which iterate through one by one and subsequently passed to copy activity to copy the data in to the sink.

    Below links further helps you to understand it. Thanks

    https://azurelib.com/foreach-activity-in-azure-data-factory-with-practical-example/

    https://www.youtube.com/watch?v=KuWYuHlUwD0

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2022-03-10T13:22:34.93+00:00