topic Re: Single Mapping Load Script in QlikView

Single Mapping Load Script

jrholden — Sun, 30 Aug 2020 19:15:17 GMT

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.

Re: Single Mapping Load Script

mikaelsc — Sun, 30 Aug 2020 19:24:59 GMT

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

Re: Single Mapping Load Script

jrholden — Sun, 30 Aug 2020 19:46:22 GMT

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.

Re: Single Mapping Load Script

Kushal_Chawda — Sun, 30 Aug 2020 20:09:32 GMT

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/SystemVariables/Include.htm

Re: Single Mapping Load Script

jrholden — Wed, 02 Sep 2020 19:09:39 GMT

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

Re: Single Mapping Load Script

marcus_sommer — Thu, 03 Sep 2020 15:34:14 GMT

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

- Marcus

Re: Single Mapping Load Script

Brett_Bleess — Tue, 15 Sep 2020 17:05:40 GMT

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/SystemVariables/Include.htm

Regards,
Brett