topic Re: Fact table concatenation problem in QlikView

Fact table concatenation problem

Thu, 12 Sep 2013 06:19:30 GMT

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

Re: Fact table concatenation problem

vikasmahajan — Thu, 12 Sep 2013 06:30:25 GMT

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

Re: Fact table concatenation problem

Sokkorn — Thu, 12 Sep 2013 06:35:03 GMT

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

Re: Fact table concatenation problem

Anonymous — Thu, 12 Sep 2013 06:43:09 GMT

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