Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want to join these 2 tables

I want to join these 2 tables to retrieve the data of WO_KCEPart, what should I do?

Paknanarn23_0-1687226613814.png

Because I used to join data using WorkOrderNo and I can't because WorkOrder table SM_Summary Workorder has only 14 but Wo_WorkOrder table OUTPUT_SM has 16 Workorder which cannot join.

Paknanarn23_1-1687226796417.png

what should i do I'm stuck here.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Do you mean the fields are of different length? It looks like WO_WorkOrderNo might have more "0" on the end? In that case, can you make the values match up with:

Left(WO_WorkOrderNo, 12) as WorkOrderNo

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

View solution in original post

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Name both fields the same. In the OUTPUT_SM load, use 

WO_WorkOrderNo as WorkOrderNo

The tables will then link. Those rows that can link (join) will, those 16 that don't join will not.  You will not lose any data.

-Rob

Paknanarn23
Creator II
Creator II
Author

I tried this, can't link table because SM_Summary table has 14 WorkOrderNo data but table OUTPUT_SM has 16 WorkorderNo data

Paknanarn23_0-1687235480766.png

 

sidhiq91
Specialist II
Specialist II

@Paknanarn23  as @rwunderlich  mentioned you can rename the field and then Qlik will automatically form an Associative join. If the data in both the fields are not matching with one another then might not get the right data. Please check the data in those 2 fields.

Paknanarn23
Creator II
Creator II
Author

I have checked the information mismatch But I want to make these two tables join together. Can you help me?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Do you mean the fields are of different length? It looks like WO_WorkOrderNo might have more "0" on the end? In that case, can you make the values match up with:

Left(WO_WorkOrderNo, 12) as WorkOrderNo

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com