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...

[#2]

Could you upload a script example?

[pgalvezt]

I have:

Table_A:

LOAD

value 1,

value 2,

value 3

From

;

CONCATENATE(Table_A) //Works Perfectly alone. Join Table A and table B

Table_B:

value 1,

value 2,

value 3

From

;

Store Table_B Into QVD\Table_B.qvd; //Problem

//Store Table_B Into QVD\Table_B.qvd; //No Problem

CONCATENATE(Table_A) //Works Perfectly alone. Join Table A and table C

Table_C:

value 1,

value 2,

value 3

From

;

Store Table_C Into QVD\Table_C.qvd;//Problem

//Store Table_C Into QVD\Table_C.qvd;//No Problem

But if I add Store function Thrown the error table.

[erichshiino]

Hi,

When you use concanate, the name you give to the table you are concatenating (the second one) is just ignored.

Then at:

Table_A: //you create this one

LOAD

value 1,

value 2,

value 3

From

;

CONCATENATE(Table_A) //Works Perfectly alone. Join Table A and table B

Table_B: //QlikView will ignore this - only Table A exists

value 1,

value 2,

value 3

From

;

If you try Store Table B you get an error because it does not exist.

Use just Store Table A ...

[#5]

At first glance I can see you don't have the 'LOAD' string in the last two tables.

Also I understand that when you concatenate a table to another, the second one won't be created in memory as an independent table so if you try to store those ones QlikView won't be able to find them.

So, if you need to store Table_B and Table_C you must load those again without using Concatenate before the 'LOAD' string.

[pgalvezt]

Thanks both of you.

I'm sorry I forgot put the Load command in the second example table. But I understood the problem that I had. Now,

How can I fix the synthetics keys problem in another way? Of course my dashboard works fine, but in the table visor its shows many tables and many associations.

Any Suggestions.

Best regards

[#7]

How can you have synthetic keys if the above script only creates one table?

Do you have more tables?

[pgalvezt]

I have 13 Tables. The association is created with the Date field.

[#9]

I forgot my suggestion:

You can always rename the fields that are not keys, or try to create unique keys concatenating multiple fields into one:

     Filed_1 & Field_2 & Field_3 as Key_Fields

[pgalvezt]

Finally I did this:

Concatenated all and Store I put:

Store Table_A Into QVD\Table_B.qvd;

Store Table_A Into QVD\Table_C.qvd;

Store Table_A Into QVD\Table_D.qvd;

and so on;

Table visor shows Now: Only One Table. And I have now 13 files qvds

Thanks both of you.