topic Re: load QVDs without associating them in QlikView

load QVDs without associating them

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

How would I load a series of qvds without concatening them and associating the fields?

The reason is I want to exports qvds as snapshots of the loading process to fix errors.

But I dont want to concatenate or associate them so I can see seperate table views, then I can understand the code.

Thanks,

Tinkerz.

Re: load QVDs without associating them

maxgro — Sat, 17 Sep 2016 16:24:17 GMT

Some options

- qualify

- noconcatenate: this is from help

The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they otherwise would be automatically be concatenated

- change the fields name so the tables don't concatenate

- also, if you store in a qvd a table, it doesn't matter if there are association, you only store that table

Re: load QVDs without associating them

el_aprendiz111 — Sat, 17 Sep 2016 17:40:45 GMT

Hi,

Re: load QVDs without associating them

shraddha_g — Mon, 19 Sep 2016 04:34:54 GMT

You can use Qualify() to alias all fields of table. it will keep from all tables from associating.

Refer below link:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Qualify.htm

Regards,

Shraddha