topic Re: Concatenate load is not loading the second Table Data in QlikView

Concatenate load is not loading the second Table Data

Anonymous — Thu, 19 Jan 2012 19:33:13 GMT

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;

Re: Concatenate load is not loading the second Table Data

vijay_iitkgp — Thu, 19 Jan 2012 19:37:20 GMT

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

Concatenate load is not loading the second Table Data

Oleg_Troyansky — Thu, 19 Jan 2012 19:40:06 GMT

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

Re: Concatenate load is not loading the second Table Data

Anonymous — Thu, 19 Jan 2012 19:46:32 GMT

it adds column only ...data is not added

Concatenate load is not loading the second Table Data

Thu, 19 Jan 2012 19:54:36 GMT

Hi Sarathi,

Can you try like this

table1 :

....

table2:

concatenate (table1)

load ...

.....

table3:

concatenate(table1 / table2)

load ....

.....

hope this helps

Meher

Concatenate load is not loading the second Table Data

Thu, 19 Jan 2012 20:31:11 GMT

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.