Partitioning based on date when Microsoft ADLS as a storage

[chandraprakash_j_volvo]

Source: SQL Server,

Target: Microsoft ADLS as csv files.

I want to run a scheduled job on daily bases. In target , it target it has to partitioned based on replication date.

Ex: If replication happens on 21 April'2025, all the csv files have to store on folder called 20250421,

similary if repllication happens on 22 April'2025, all the csv files have to be stored on folder called 20250422.

Is there a way to create a folder and then store the file? 

[john_wang]

Hello @chandraprakash_j_volvo ,

I'm not entirely clear on the exact requirements, could you please clarify the following points?

1. Is this task intended to be Full Load only?

2. Or is it related to Change Processing (store changes)? Or does it involve both?

3. When you mention the folder (e.g., 20250421), are you referring to:

   • A subfolder under each specific table folder?

   • Or a single folder (e.g., 20250421) that contains files for all tables?

BTW, I'm not sure if we can achieve that. Let's try our best.

Regards,

John.

[john_wang]

Hello @chandraprakash_j_volvo ,

Please check the article: Qlik Replicate - can we create different runtime folder for change tables based on tasks run time. 

Hope it helps.

John.