topic Re: Crosstable auto concatenation in QlikView

Crosstable auto concatenation

Anonymous — Wed, 26 Mar 2014 04:28:32 GMT

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

Re: Crosstable auto concatenation

rwunderlich — Wed, 26 Mar 2014 04:59:27 GMT

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

Re: Crosstable auto concatenation

Anonymous — Wed, 26 Mar 2014 05:02:54 GMT

It doesnt work!! Says Illegal combination of prefixes

Re: Crosstable auto concatenation

rwunderlich — Wed, 26 Mar 2014 05:13:42 GMT

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

-Rob

Re: Crosstable auto concatenation

Anonymous — Wed, 26 Mar 2014 06:16:50 GMT

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

Re: Crosstable auto concatenation

qlikpahadi07 — Wed, 26 Mar 2014 06:25:56 GMT

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

Re: Crosstable auto concatenation

its_anandrjs — Wed, 26 Mar 2014 06:29:20 GMT

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

Re: Crosstable auto concatenation

Wed, 26 Mar 2014 06:29:32 GMT

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

Re: Crosstable auto concatenation

rwunderlich — Wed, 26 Mar 2014 19:23:37 GMT

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

-Rob

Re: Crosstable auto concatenation

Anonymous — Mon, 07 Apr 2014 02:14:17 GMT

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.