Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
AnujGupta
Contributor III
Contributor III

Create Partition based on CDCT column

Hello Team, 

I am using data bricks Lakehouse delta connector & used CDCT column value as $AR_H_COMMIT_TIMESTAMP. I need to create a partition based on CDCT column with Year, Month, day. How is that possible using Qlik Replicate. 

Version I am using November 2022 (2022.11.0.28)

Need below output in storage account location - 

AnujGupta_3-1698938141880.png

 

 

 

3 Replies
OritA
Support
Support

Hi, 

Could you please open a case for this question and provide the details of  the table DDL so we can provide you the relevant instruction accordingly. 

 

Thanks & regards,

Orit

AnujGupta
Contributor III
Contributor III
Author

Hi , 

I am using CDCT column $AR_H_COMMIT_TIMESTAMP. 

AnujGupta_0-1699003398961.png

It is populating data but in external location of ADLS it is not creating data based on partitions yyyy/mm/ddAnujGupta_1-1699003458491.png

AnujGupta_2-1699003538203.png

AnujGupta
Contributor III
Contributor III
Author

00123140: Create Partition based on CDCT column