Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 : )
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:
hope this helps.
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.