topic Re: Is this a fair statement regarding caution when joining? in QlikView

Is this a fair statement regarding caution when joining?

Fri, 04 Dec 2015 23:00:43 GMT

Hi, Qlikviewers-

I've been putting a lot of time in on the join/keep/concatenate info and it makes good sense.

Can you all tell me if I'm interpreting this correctly:

Join may make sense if you are combining tables that only contain dimensions (and don't need to count the instances of them)...it's when you have tables that have facts/numeric value fields that you'll see record repetition cause problems....in your final table you'll be using instances of values and thus be overstating aggregates...

Thanks!

Camilla

Re: Is this a fair statement regarding caution when joining?

robert_mika — Sat, 05 Dec 2015 05:44:29 GMT

look here

Join Vs Concatenate

Merging Data from Multiple Sources

Re: Is this a fair statement regarding caution when joining?

yadav_anil782 — Sat, 05 Dec 2015 06:56:29 GMT

HI Camilla,

i hope this will help you Understanding Join, Keep and Concatenate

Re: Is this a fair statement regarding caution when joining?

Sun, 06 Dec 2015 16:41:35 GMT

I've read those, but there's not a lot of info about the differences in terms of practical use

Re: Is this a fair statement regarding caution when joining?

Sun, 06 Dec 2015 16:49:43 GMT

Thanks, Robert! I can't believe with all the searching I did, that the Merging Data page hadn't popped up before.