Function Concatenate and Store

[pgalvezt]

Hello, first of all congratulations for this update, really is amazing the visualization of this page.

Recently I fixed a problem with syntethics keys witn the "Concatenate "Function. Finally Qlikview only shows one single table . But now my problem is that I incluided into the script the Function "Store" and to do qvd files for incremental Charges. And Qlikview Shows a massage: Qlikview doesn't founfd the table. If I left under comment the concateate function the Script Works. The problem is Both Concatenate and Store working together they thrown this error.

I hope you guys can help me.

Best Regards...

[erichshiino]

Did you check your QVDs? Aren't they all the same?

[pgalvezt]

I was on it, you´re right all the qvd's files are the same. mmm I think I'm ging to eliminate the Store Function.

If you have another alternative please let me know thanks.

[#4]

Since all your fields are called the same I think you could You could also concatenate the latest tables with a flag so that after you store table A, you can do resident loads from it using where and looking for the flags you set before. That way you'll store only the records that belong to each different table.

Table_A:

Load *, '1' AS FLAG

From

;

STORE Table_A into QVD\Table_A.qvd;

concatenate (Table_A)

LOAD *, , '2' AS FLAG

From

;

concatenate (Table_A)

LOAD * , '3' AS FLAG

From

;

Table_B:

LOAD *

RESIDENT Table_A

WHERE FLAG='2';

STORE Table_B into QVD\Table_B.qvd;

Drop TABLE Table_B;

Table_C:

LOAD *

RESIDENT Table_A

WHERE FLAG='3';

STORE Table_C into QVD\Table_C.qvd;

Drop TABLE Table_C;

[erichshiino]

This will probably work.

Just include a noconcatenate before creating Table_B from table A. Since

they have the same fields, QlikView will auto-concatenate them.

Adjust your code to something like this:

noconcatenate

Table_B:

LOAD *

RESIDENT Table_A

WHERE FLAG='2';

STORE Table_B into QVD\Table_B.qvd;

Drop TABLE Table_B;

(reply by email!)