Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
Former Employee
Former Employee

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