topic Re: Interval Matched tables to QVD in QlikView

Interval Matched tables to QVD

Anonymous — Thu, 12 Nov 2015 14:38:32 GMT

Good day,

I would like to find out if there is a way in which one can write the data from two interval matched tables to a QVD.

With the model linking the two tables, one can use the columns in a chart, however I would like to write this result to a QVD file for use in other applications.

Any ideas on this ?

Kind regards

Edwin

Re: Interval Matched tables to QVD

oknotsen — Thu, 12 Nov 2015 14:51:50 GMT

STORE TableName1 into TableName1.qvd;

STORE TableName2 into TableName2.qvd;

If that does not answer your question, please clarify what you are trying to achieve.

Re: Interval Matched tables to QVD

Anonymous — Thu, 12 Nov 2015 14:59:26 GMT

No, I would like to write the "result" of the match to a QVD:

i.e.

QVD_FILE:

TABLE1.COLUMN T1_A, TABLE1.COLUMN T1_B, TABLE1.COLUMN T1_C, TABLE2.COLUMN T2_AA

the last column coming from the second table.

Typically one can construct this with a join command to get all the required columns in one RESIDENT table, but that is not the case with two interval matched tables.

So basically the interval match result which one achieves in a chart to QVD.

Re: Interval Matched tables to QVD

oknotsen — Thu, 12 Nov 2015 15:42:25 GMT

I might be overlooking something obvious, but how about just joining those two tables and storing it to QVD?

If you want to keep the original two tables, you can create a copy of those tables with a RESIDENT load (use NOCONCATENATE to avoid concatenation).

Re: Interval Matched tables to QVD

maxgro — Thu, 12 Nov 2015 18:42:03 GMT

1 qvd is 1 table;

you can't write a qvd from 2 qlik tables;

you can join or concatenate in the script and store in the qvd; you can export from the chart (excel, ....) but not export from the chart to a qvd

Re: Interval Matched tables to QVD

Anonymous — Thu, 12 Nov 2015 19:19:01 GMT

Onno's suggestion of 2 QVD's is very sensible, is something I do and it works very well.

Any reason why you have an aversion to 2 QVD's ?

Re: Interval Matched tables to QVD

Anonymous — Fri, 13 Nov 2015 06:27:02 GMT

Thank you for the suggestions. The reason for having this in one QVD is that I want to join the complete set with another data set to calculate values in a script in order to prepare an final data set.

Previously I've saved the char to excel and I am using that as import for the other application.

Once again thank you for your inputs it's really appreciated.

Kind regards

Edwin

Re: Interval Matched tables to QVD

oknotsen — Fri, 13 Nov 2015 07:11:42 GMT

If your question is answered, please flag a Correct answer and a Helpful answer.

If not, please let us know how we can help you achieve this.