Crosstable auto concatenation

[Anonymous]

I have an excel sheet containing three tables. I am loading all three (Tables A,B,C) as crosstables (with different no. of fields in each) . Yet my data from first table (Table A) shows in the data of second table (Table B) which has a lot of empty cells!! please advice. I cannot upload the sheet either.

table1:

....

TableA:

CrossTable(Month, Data, 10)

concatenate(Table1)

resident TableA

..

TableB:

CrossTable(Month, Data, 11)

...

concatenate(Table1)

resident TableB

TableC:

CrossTable(Month, Data, 12)

..

concatenate(Table1)

resident TableC

..

[rwunderlich]

It looks like you are getting automatic concatenation -- which QV does whenever tables share the same field names. You can try overriding that by adding the NoConcatenate prefix to the CrossTable statement.

-Rob

[Anonymous]

It doesnt work!! Says Illegal combination of prefixes

[rwunderlich]

How about if you drop TableA after you concatenate it with Table1?

-Rob

[Anonymous]

Since I am concatenating on resident load, anyway i am dropping the tables there. I have tired few other ways now. Still it is getting concatenated Phew!!!

[qlikpahadi07]

Hi Ruchi,

As you can't attach the excel I suggest you to do some RND with steps like

Step 1:

create a new App and Load all 3 table one by one with Check

Load Table A

check on Front end all data and columns are as expected?

Load Table B

check on Front end all data and columns are as expected?

Load Table C

check on Front end all data and columns are as expected?

Step 2:

concatenate all Three and Check which will be Table ABC.

Step 3:

Concatenate Table ABC  with Table 1 and drop Table ABC.

it should work

.. Good Luck

[its_anandrjs]

Hi,

While cross table creation try to make QVD of that table and then load one by one table and then concate that tables with check the fields in the tables.

Hope this helps

Thanks & Regards

[#8]

Change Attribute and Data field names for all the 3 tables.

[rwunderlich]

Can you post the actual script -- and document log -- instead of the pseudo code?

-Rob

[Anonymous]

Sorry for the late reply. I re did it in a totally different manner. I took three tables, normal loads and stored them in 3 QVDs.

From the QVDs when I am doing a cross table on them... it works fine.

Thank you all so much.