How to Append a QVX file !

[#1]

Hi All,

Anyone plz help on this.

How to Append a QVX file.

Thanks in Advance !

[jonathandienst]

Hi

Not sure what you are looking for:

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

Jonathan

[#3]

Append data to a QVX file

[jonathandienst]

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

[#5]

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.

[jagan]

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.

[#7]

Jagan,

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

[jagan]

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.

[jonathandienst]

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.