topic Re: How to Append a QVX file ! in QlikView

How to Append a QVX file !

Tue, 10 Mar 2015 05:21:57 GMT

Hi All,

Anyone plz help on this.

How to Append a QVX file.

Thanks in Advance !

Re: How to Append a QVX file !

jonathandienst — Tue, 10 Mar 2015 05:32:41 GMT

Not sure what you are looking for:

Append data to a QVX file?
Add a QVX file to a Qvw document?

Jonathan

Re: How to Append a QVX file !

Tue, 10 Mar 2015 05:51:40 GMT

Append data to a QVX file

Re: How to Append a QVX file !

jonathandienst — Tue, 10 Mar 2015 06:00:38 GMT

In principle, all you need to do is load the data to be appended, concatenate the QVX data into the same table and save the resulting table back into the QVX file. Or you can load the QVX first, then concatenate the data to be appended - it depends on your implementation.

If you need specific help on how to do he above, I suggest that you post a sample model, a sample QVX file and some sample data to append.

My understanding is that will work the same way as incremental loading from and appending to a QVD file - although the QVD file will load faster.

HTH

Jonathan

Re: How to Append a QVX file !

Tue, 10 Mar 2015 06:07:48 GMT

Hi Jonathan,

I have two flow in ETL .it 's creating two QVX files. But i want one flow which combines both the flows and append the data in QVX file.

Re: How to Append a QVX file !

jagan — Tue, 10 Mar 2015 06:18:16 GMT

Hi,

Try like this

Data:

LOAD

FROM FielName.qvx (qvx);

Concatenate(Data) -- Appending data to the qvx

LOAD

FROM DataSource;

STORE Data INTO FielName.qvx; // Storing appended data to the qvx file again

Hope this helps you.

Regards,

Jagan.

Re: How to Append a QVX file !

Tue, 10 Mar 2015 06:21:03 GMT

Jagan,

Can we do something outside of qlikview? Requirement is to do in informatica flow

Re: How to Append a QVX file !

jagan — Tue, 10 Mar 2015 06:43:09 GMT

Not sure about Informatica, but there should be some option like Append or Union All datasets in any ETL tools. Check for those options. check below link

loc.gov/z3950/agency/wisdom/pending/merge.html

Regards,

Jagan.

Re: How to Append a QVX file !

jonathandienst — Tue, 10 Mar 2015 07:43:32 GMT

Is Informatica generating the QVX files? Then you could add both sets of data directly to the QVX in Informatica. Or you could simply concatenate the 2 QVX files in Qlikview.