topic Re: Copying Sections of Data Load Editor Using Automation in Qlik Automate

Copying Sections of Data Load Editor Using Automation

AJDoc31 — Sun, 23 Mar 2025 20:46:51 GMT

Hello All,

I am currently working on an application that will ultimately be used as a source for change management within my team. That is to say, we would have one 'source of truth' and apply this template to subsequent dashboards. I have been building automations and ran into this issue. Every application we manage has a different SQL query for their respective data. There is logic for QVD storage, partial reloads, and master calendars that I would like to have within this templated application. The question I have is, is there a way to copy the load script from the template application and update the sections of the target application while leaving the other sections alone?

For Example:

Template application load script sections:

QVD Logic, Reload Logic, Master Calendar

Target application load script sections:

QVD Logic, Reload Logic, SQL Query and Table Load, Master Calendar

I want to be able to push updates to each application if I change the load script on the template. Is this possible or not? I can not use the MUST_INCLUDE or INCLUDE functions with text files (that would be the easiest solution here) as I have to export the QVF and have another application host the dashboard so I need the script in each QVF.

TIA!

Re: Copying Sections of Data Load Editor Using Automation

henrikalmen — Mon, 24 Mar 2025 08:59:17 GMT

There's an old discontinued(?) open source project that probably does (did) what you want: https://github.com/ptarmiganlabs/butler-app-duplicator

Perhaps ptarmiganlabs moved the functionality into some other project, I don't know. Perhaps you could find something there...

Re: Copying Sections of Data Load Editor Using Automation

AJDoc31 — Sun, 30 Mar 2025 23:40:55 GMT

I was able to do this with a custom code block in the automation space using python. It was very straight forward separating out each section by the '///$tab' phrase

Re: Copying Sections of Data Load Editor Using Automation

marksouzacosta — Mon, 31 Mar 2025 01:46:04 GMT

Hi @AJDoc31,

I have made a process to dynamically create Qlik Sense Apps using Automations and Script Templates with replaceable areas, very similar to what you have described.

You can find the full Automation Code here - it is part of a bigger article that I'm finishing up:
https://github.com/Data-Voyagers/ParquetVsQVD/blob/main/Automations/Parquet%20vs%20QVD%20Tests%20-%20Create%20Scripts%20-%20Reduced%20Columns.json

Regards,

Mark Costa