Concatenate load is not loading the second Table Data

[Anonymous]

Calender:

load Model,

     year,

    month(month) as MONTH,

    Date(Monthstart(month), 'MMM-YYYY') as YearMonth,

    'Q' & Ceil(Month(month)/3) as Quarter,

    Dual(Year(month) & '-Q' & Ceil(Month(month)/3), Year(month) & Ceil(Month(month)/3)) as YearQtr

    resident MobileTable;

Concatenate LOAD  

                 Model, 

                 year(Month)as year,

    month(Month) as MONTH,

    Date(Monthstart(Month), 'MMM-YYYY') as YearMonth,

    'Q' & Ceil(Month(Month)/3) as Quarter,

    Dual(Year(Month) & '-Q' & Ceil(Month(Month)/3), Year(Month) & Ceil(Month(Month)/3)) as YearQtr

    resident HardDiskTable; 

[vijay_iitkgp]

It Must be concatenating the tables. You can check it by adding one more column like Year&Month as Yearmonth in second table and see the result.

Regards

VIjay

[Oleg_Troyansky]

1. It looks like your existing resident tables MobileTable and HardDiskTable were loaded before, and they might have an identical structure... Check that both tables exist (and not concatenated together) prior to those two statements.

2. The structure of those 2 loads should result in automatic concatenation, so you don't have to specify "Concatenate". However, if you do, make sure that there are no other load statements between those two, or specify explicity what table (Calender) you want to concatenate to.

cheers,

Oleg

[Anonymous]

hi

      it adds column only ...data is not added

[#5]

Hi Sarathi,

Can you try like this

table1 :

....

....

....

table2:

concatenate (table1)

load ...

.....

.....

table3:

concatenate(table1 / table2)

load ....

.....

.....

hope this helps

Meher

[#6]

Is it possible that MobileTable and HardDiskTable contain the same data? With the fields you are loading any duplicate data will tend to disappear because of the way QlikView stores field values. I would suggest two things: 1. In document properties, General tab turn on the log - that will help you see the number of rows loaded from each load statement. And, 2., Under the load statement for HardDiskTable add one more field:  1 as HardDiskTable_flag. Then, after the data is loaded you can select on that field and see what was loaded from the second load statement, if anything was loaded.