topic Need Clarification in QlikView

Need Clarification

Nagaraju_KCS — Fri, 10 Jul 2015 07:52:13 GMT

Hi Community,

I have 10 tables, all data required in 10 tables, and i have 5 to 10 fields are same in the tables.

Which one is better??

Concatenate or Link table??

Please anyone can explain...!!!

jagan — Fri, 10 Jul 2015 08:01:13 GMT

Hi,

Go for Link table, if all tables are having different data and common fields.

Regards,

jagan.

Nagaraju_KCS — Fri, 10 Jul 2015 08:23:29 GMT

Hi Jagan,

Thanks for reply,

I have 3 tables almost same fileds.

Actually i have created Flag for each table, and concatenate 10 tables.

is this make sense??

or can i do Linktable??

jagan — Fri, 10 Jul 2015 08:34:55 GMT

Hi,

Generally we will go for Concatenation only when we have all common fields, otherwise use Link table.

Regards,

Jagan.

vcanale — Fri, 10 Jul 2015 08:36:32 GMT

Hi,

robert_mika — Fri, 10 Jul 2015 09:49:17 GMT

If you in doubt post your model pictures

Anonymous — Fri, 10 Jul 2015 11:14:14 GMT

if few tables have similar columns as u mentioned 3 tables u can concatenate them and link the rest of the tables.