topic Re: Load script is not bringing in table information as expected in App Development

Load script is not bringing in table information as expected

Ken_Hardwick — Tue, 15 Feb 2022 13:19:43 GMT

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.

Thanks

Re: Load script is not bringing in table information as expected

Or — Tue, 15 Feb 2022 13:40:32 GMT

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:

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

Re: Load script is not bringing in table information as expected

Ken_Hardwick — Tue, 15 Feb 2022 14:25:04 GMT

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.

Re: Load script is not bringing in table information as expected

Or — Tue, 15 Feb 2022 15:20:37 GMT

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

Re: Load script is not bringing in table information as expected

Ken_Hardwick — Tue, 15 Feb 2022 21:31:04 GMT

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