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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
theresa_me
Contributor
Contributor

From Qlik to Git - Pushing data in csv format

Hey there, 

we want to push our dataframe/datamodel we created Qlik to our Git repository in a csv format, so the dataframe is available in git as a csv dataframe. We would like to automize this task on a monthly basis. We are using Qlik Enterprise.

Anybody knows if thats possible - and if, how? 

Thanks in advance! Looking forward to your input : )

 

Labels (4)
2 Replies
GTiscareno
Employee
Employee

do you have Nprinting? is so that will a quick solution, check the article

https://community.qlik.com/t5/Qlik-NPrinting/Distributing-CSV-file-in-nprinting/td-p/1051384

if not you can use in your load script the you can have at the end STORE-statements that can store an in-memory table in a text (CSV)-file or a QVD-file.  Check the next article:

https://community.qlik.com/t5/App-Development/Excel-CSV-Automation-of-a-Report-in-QlikSense/td-p/124...

hope this helps.

 

 

 

 

 

Marc
Employee
Employee

As part of your load script you would use a store command to export the data to a CSV file.

You would then need to commit that file change into git.

 

How I would set this up would be.

Clone the Remote Git repository to a local location.

 

Set the App reload script to export the CSV using the "Store" command into the local git repo.

Set a "External Program Task" to run a PowerShell script to perform the Git Commit & Push
Link the External Program Task to run upon successful completion of the App Reload.