topic left join in QlikView

left join

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone

I have a table contains fields name, year,month,day and another table contains name, year,month

I wanna left join these two tables

How i can do that(i don't have a field day in second table and it causes repeating data )?

i would appreciate if someone can help

Re: left join

Gysbert_Wassenaar — Sat, 18 Feb 2017 08:36:45 GMT

Why do you think you need to join these tables?

Perhaps this blog post helps: Fact Table with Mixed Granularity

Re: left join

Anonymous — Sat, 18 Feb 2017 08:43:03 GMT

because these tables have other fields and i need to join

Re: left join

Anonymous — Sat, 18 Feb 2017 09:10:23 GMT

i read the blog post but i can't understand completely for my problem

can you give me a solution with my tables?

Re: left join

nitin_01 — Sat, 18 Feb 2017 09:48:30 GMT

Hi elham,

I don't think so it would produce or create a repeating data after joining the tables but it might create missing values depending upon non-matching records.

Regards

Nitin

Re: left join

Anonymous — Sat, 18 Feb 2017 10:01:41 GMT

example of my tables

table one

name,year,month,day...

elham,2010,02,22,...

elham,2010,02,21,....

left join

table 2

name,year,month,accident price

elham,2010,02,24000

accident price repeat 2 times because we have 2 rows in table 1

what can i do to solve this problem?

Re: left join

nitin_01 — Sat, 18 Feb 2017 10:17:11 GMT

Hi elham,

output:

Regards,

Nitin.

Re: left join

Anonymous — Sat, 18 Feb 2017 10:40:48 GMT

sorry i wrote a same day by mistake.

i correct above example please check it again

Re: left join

nitin_01 — Sat, 18 Feb 2017 11:05:15 GMT

Hi elham,

Yes it will repeat in this case, But there should be another key field in your data that identifies or mapped with your field 'accident price' that shows different value for each line of record and that will remove your repeating data.

You can add that field to remove duplication.

Regards,

Nitin.

Re: left join

Anonymous — Sat, 18 Feb 2017 11:11:04 GMT

i don't have a field day in table2 , my "accident price" is for whole month not a specific day

is there any way to join these tables?

Re: left join

nitin_01 — Sat, 18 Feb 2017 12:38:03 GMT

Yes I can see that.

I would suggest to find the key field that gives you different value for each record of line for 'accident price' and put it in your table or else values will be repeating.

Regards,

Nitin.

Re: left join

Gysbert_Wassenaar — Sun, 19 Feb 2017 18:16:52 GMT

Make a choice. To which day should to accident price be joined? Or should it be distributed over the days of the month? What is the result you expect?