Spiltting and writing files to Azure Storage Container as target

[vinodn1989]

From Sql Server, I have data with Year column included, I want to write the data to target azure blob storage container in parque format by splitting incoming data by year into seperate file.Any possibility and needs help with the steps?

[john_wang]

Hello @vinodn1989 

It appears there are two possible options:

1. Use post-processing in Azure Storage
   After data is loaded, implement a post-processing step in Azure Storage to split the data into multiple files, organized by year.

2. Create multiple tasks in Qlik Replicate
   Configure separate Qlik Replicate tasks, each targeting a specific year of data. This approach ensures that each year's data is written to its own dedicated file.

Regards,

John.