Automation - Export Master Items to Excel Workbook - Issues when exporting Master Dimensions

amargarit — Mon, 18 Nov 2024 10:24:49 GMT

Hi,

I have recently saw that a new template for automation called "Export Master Items to Excel Workbook " has been added in QlikSense Cloud and wanted to use it for backing up our Master Items from multiple apps.

When trying to use it I have received a lot of errors in the Add Row to Table block:

I have noticed that we are getting errors when we try to read from Label Expression for a Master Dimension because the contents have a newline, basically the expression has been created on multiple rows (for more readability).

I have been using the JSON formula which wraps the contents for Label Expression read from the Master Dimension as specified in one of the Community threads with no success:

I have also used Replace formula to find the newline character (\n or \n\r ) and replace it with comma but the same error appears.

I keep getting error on the same step and wanted to check if anyone has different ideas and/or solutions.

I have been expecting that the default template provided by Qlik for this kind of automation will work out of the box but I guess more development is needed, since I would not modify any existing Master Item to make the Automation work , but instead the other way around, we should be able to have a complete automation capable to export all Master Items.

Thanks a lot for your help and let me know if you need more details!

With kind regards,

Andrei

topic Automation - Export Master Items to Excel Workbook - Issues when exporting Master Dimensions in Qlik Automate

Automation - Export Master Items to Excel Workbook - Issues when exporting Master Dimensions