Joining of tables

[#1]

Hi,

Am having data in two different hive tables,want to join that two different hive tables through date as primary key. It would be helpful if any one helps.

Regards,

Tejavardhana.

[sushil353]

it would be great if you put some sample data..

other wise qlikview join tables on the bases of samefield names

the syntex for join is

table1:

load * from xyz.xl

join (table1)

table 2:

load * from abd.xl

HTH

Sushil

[kaushiknsolanki]

Hi,

     Try this.

     Keep the same name of the field which you want to join. Something like below.

     Load Field1, Date from xyz;

     Load Field2,Date from pqr;

     QlikView will link them by default on the basis of same name.

Regards,

Kaushik Solanki

[er_mohit]

using floor function in other table which you want to join

like date(floor(datefield))

hope it helps

[#5]

hi

write your datefield as given below in both table.

Date(floor(datefield))

[#6]

Use Num() function on Date and join the tables.

eg Num(Date).

[#7]

Well you are not providing much info here,

anyway QV will do a automatic join if the fields have the same name.

So just rename using AS and you will get your join done.

This if i understood your problem correctly.

Cheers,

JP