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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.