topic Re: replicate the datamodel in QlikView

replicate the datamodel

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

there is 2 qvd files. file1.qvw and file2.qvw. which is the best way to replicate data model from file1 to file2?

Re: replicate the datamodel

olivierrobin — Mon, 09 Jul 2018 07:38:59 GMT

hello

in you 2nd qvw (and not qvd) you can use

binary file1.qvw as 1st statement to copy datamodel

Re: replicate the datamodel

nishanthi_8 — Mon, 09 Jul 2018 07:39:17 GMT

Binary load

Re: replicate the datamodel

qlikviewwizard — Mon, 09 Jul 2018 08:41:43 GMT

May be this one:

Write this in file2.qvw :

Binary file1.qvw ;
QVD1:
LOAD *  From QVD1;
QVD2:
LOAD * From QVD2;

Recreate file1.qvw variables in files2.qvw.

Hope this will help you.

Re: replicate the datamodel

sumit_ranjan_pa — Mon, 09 Jul 2018 08:49:47 GMT

HI ,

You can try two methods.

1. Copy the scripts from one QVW to second one. You will have the data model ready for you.

This will not be a good option as you will have to check on many issues in security.

2, This is a viable one. use binary load. You can load the QVW, to a new QVW. With this method, you will have the data from file1.qvw loaded into the file2.qvw. You can add extra script to the file2.qvw and add fields to the data model.

You can check more here.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Binary.htm‌

Please mark answers, as helpful and correct in case you find them useful.

Thanks and regards,

Sumit

Re: replicate the datamodel

qlikviewwizard — Tue, 10 Jul 2018 03:08:51 GMT

Hi narasaiah

Did you able to solve this?