Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
andreyfcdk91
New Contributor III

Missing values in connection tables in load script

Good day!

In load script i have three tables:

Sales:

Distributor_id

Route_Id

Link_Table:

Distributor_id

Nomenclature_id

Date

Distributors:

Distributor_id

Distributor_name

But when i add to table Sales two fields Nomenclature_id,Date, make autonumberhash key and connect it with link table:

Sales:

load

Distributor_id

Nomenclature_id,

Date,

Route_Id

autonumberhash128(Distributor_id,Nomenclature_id, Date) as Key

from...

outer join(Link_Table)

load

Distributor_id

Nomenclature_id,

Date,

Key

resident  Sales;

drop fields Distributor_id,Nomenclature_id,Date from Sales;

i have missing values in field Route_id in result, when i make straight table with fields Distributor_id, Route Id:

 

ROUTE_IDDistributor_Id
1688345321
1688364916
168837639
1688376518
1688375714
1688376415
1688293727
1688345110
168826005
1688345212
168837586
168826014
1688345411
168832393
3
4
5
6
9
10
11
12
14
15
16
18
21
27

I think,  problem connected with values Nomenclature_id,Date in Link Table (they have some values, which are not match in table Sales)

Have anyone idea how to connect correctly these three tables?

Thanks.

Community Browser