Single Mapping Load Script

[jrholden]

Is it possible to read mapping load code from an external document?  I am asking because I have multiple applications that use the same mapping load script and every time I need to make a change to the code I have to update it in multiple locations.  It would make my life much easier if I could update the code in a single location.  I use a similar technique with my variables.   However, I have not found a similar solution to my mapping load issue.

[mikaelsc]

organize your projects/data in 2/3 layers... with reusable qvd's.

https://community.qlik.com/t5/New-to-Qlik-Sense/Three-Layer-Architecture-In-Qlik/m-p/1197497

[jrholden]

I do not have any control over our architecture.  However,our projects are organized in a 3 layer architecture with reusable qvds.  However, our data models are denormalized; hence the need to use the same mapping load for multiple applications.   I must be miss understanding your response to my issue.

[Kushal_Chawda]

Probably you can save your mapping load script in QVS file.  Then you can call that QVS file in load script editor using include statement in start of the script. So if you need any changes you can do it in QVS file and save it. see below links

https://community.qlik.com/t5/New-to-QlikView/how-to-create-a-qvs-file-using-a-notepad/td-p/960655

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemVariable...

[jrholden]

I have experience in loading a .txt file but it does not work the same when loaded as a mapping load.

[marcus_sommer]

I think you need to elaborate a bit more what you did and what not worked - any errors, unexpected results, nothing happens ... ?

- Marcus

[Brett_Bleess]

You do not need QVS file, just a text file and the Include statement, the file contents will be treated as script automatically, see the following Help link, hopefully this gets you squared away.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Syste...

Regards,
Brett