Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ken_Hardwick
Contributor III
Contributor III

Load script is not bringing in table information as expected

Hello,

I am sruggling to figure why the below load script will not bring in pickers names as expected.

Picking_information:
Load Right(SalesOrder,6) AS [Sales order number],
Date#(DATE(PickDate, 'DD/MM/YYYY'), 'DD/MM/YYYY') AS [Pick date],
ScanUserID AS [Picker ID];
SQL SELECT SalesOrder,
PickDate,
ScanUserID
FROM "TL_Select_A".dbo."tbl_Picking_Log";

Picker_information:
Load ID AS [Picker ID],
FIRST_NAME AS [Picker name];
SQL SELECT ID,
FIRST_NAME
FROM "TL_Select_A".dbo."APP_USER";

Left Join (Picking_information)
Load [Picker ID],
[Picker name]
Resident Picker_information;
Drop table Picker_information;

Below is the table from the model viewer where I would expect to see a name.

Ken_Hardwick_0-1644931019791.png

Thanks

1 Solution

Accepted Solutions
Or
Master III
Master III

Some other things to check:

* The ID column has the same datatype on both sides (if not, explicitly format them to be the same datatype)

* There is actually a matching picker name for the IDs in question

* There are no other fields/selections that might potentially impact this join

View solution in original post

4 Replies
Or
Master III
Master III

You might be having a concatenation issue on the third load, not sure if that'd be the case. Third step doesn't seem necessary here, try:

Picking_information:
Load Right(SalesOrder,6) AS [Sales order number],
Date#(DATE(PickDate, 'DD/MM/YYYY'), 'DD/MM/YYYY') AS [Pick date],
ScanUserID AS [Picker ID];
SQL SELECT SalesOrder,
PickDate,
ScanUserID
FROM "TL_Select_A".dbo."tbl_Picking_Log";

Left Join
Load ID AS [Picker ID],
FIRST_NAME AS [Picker name];
SQL SELECT ID,
FIRST_NAME
FROM "TL_Select_A".dbo."APP_USER";

Ken_Hardwick
Contributor III
Contributor III
Author

You are right, the third step isn't necessary. I have tried so many different ways to solve this issue and ended up with that but I think my first attempt was inline with your recommendation.

I have tried your solution and I'm getting the same result.

Or
Master III
Master III

Some other things to check:

* The ID column has the same datatype on both sides (if not, explicitly format them to be the same datatype)

* There is actually a matching picker name for the IDs in question

* There are no other fields/selections that might potentially impact this join

Ken_Hardwick
Contributor III
Contributor III
Author

Thanks for those suggestions. The datatype turned out to be the issue.