Problem in creating the QVD's when 3 tables are there with the same name

[#1]

Hi

When following things are there in the edit script. Once I reload I am able to see only A.qvd in the edit folder but when I see in the Table Box I can see A-1,A-2 as well. Why QVD files are not created for that.

A:
SQL Select B,C,D from A;
Store A into A.qvd (qvd);
A:
SQL Select B as BB,C as CC,D as DD from A;
Store A into A.qvd (qvd);
A:
SQL Select B as BBB,C as CCC,D as DDD from A;
Store A into A.qvd (qvd);

[#2]

Hi

Use below Script

A:

SQL Select B,C,D from A;

Store A into A.qvd (qvd);

A1:

SQL Select B as BB,C as CC,D as DD from A2;

Store A1 into A1.qvd (qvd);

A2:

SQL Select B as BBB,C as CCC,D as DDD from A2;

Store A2 into A2.qvd (qvd);

[#3]

Hi paten.nayan,

Thanks for your reply!

I think you have misunderstood me. It is getting loaded from the same table not from three different tables like the way you have loaded.

[martinpohl]

Hello

don't know what you exactly want but you define three times, QV cannot create three table within the same name so they will be declared by -1 and -2.

If you look to the result you will see that all times the datas in the qvd are the same because you store always the table A.

So: If you want to replace the datas drop table A afte the store statement. But do you really want to replace the datas?

Regards

[marcohadiyanto]

hi,

just want to know, what your point to make 3 tables.

if you want to join them. use function "concatenate or join" but you must understand that function.

regard,

Marco

[#6]

What paten.nayan wrote was almost ok! This is what you want, still don't know why you want it this way!

A:
SQL Select B,C,D from A;
Store A into A.qvd (qvd);

A1:
SQL Select B as BB,C as CC,D as DD from A;
Store A1 into A1.qvd (qvd);

A2:
SQL Select B as BBB,C as CCC,D as DDD from A;
Store A2 into A2.qvd (qvd);