Fact table concatenation problem

[#1]

Hi Guys,

I have created a link table in my data model as I have two different type of fact tables.

After concatenation, I did a reload and when I checked the table viewer, in the link table there is not data displayed from the second table

In the link table preview I can see only data from the first table.

Is there any limitation in the number of rows displayed in the table viewer--> preview.

Or something wrong with the data model.

Anybody faced this issue before, plz let me know.

Thanks and Regards,

Praveena

[vikasmahajan]

Hii,

IF 2 tables fields are same then after loading data into Qlikview It concatenates automatically will be merged into single fact table.

while loading second table use noconcatenate keywords.

Hope this helps you.

Vikas

[Sokkorn]

Hi Praveena,

By default, table preview in table view show 1000 records only. You can extend preview record by click on Help -> About QlikView ->

Just an idea when do concatenate table, we should add new field to identify record for each table; something like;

[Data]:

LOAD

     'T1'     AS [Type],

     Field  AS [Field1],

     ...

FROM TABLE...

Concatenate([Data])

LOAD

     'T2'     AS [Type],

     Field  AS [Field1],

     ...

FROM TABLE...

Regards,

Sokkorn

[Anonymous]

Hi Praveen,

In qlikview if two tables have same field names then it automaticaly concatenate into single table,

for the second table you create a new field like '1' as Flag, then reload the data you will get entire data in table preview.

LOAD

     'T1'     AS [Type],

     Field  AS [Field1],

     ...

FROM TABLE...

Concatenate([Data])

LOAD

     'T2'     AS [Type],

     Field  AS [Field1],

    '1' as Flag,

     ...

FROLoM TABLE...

regards

arun