this?
@atuljainajm Count how many bins you have set up in part maintenance and post it here.
Atul, now look through each of those rows. Select each row and then navigate to the “Bin Information” tab.
How many of those rows have a record in the Bin Information tab with the circled fields filled out?
Tell me how many of those bins have these fields filled out?
If I could solve all this in two seconds would you be open to it?
We need a live chat and screen share for situations like this. Discord or something, that’s what the kids use these days, right?
Atul, tell me how many records you’re getting in your text file.
@atuljainajm, you told me that there are two part bin info records for your part, part 1005-03.
So… it makes sense that in your text file dataset, you are seeing two rows… one for each of the partbininfo rows that exist for your part. It makes sense because in your join you aren’t doing anything to specify which of the two partbininfo records you want are you? You’re just saying give me all the partbininfo rows where the part number is 1005-03… and there are TWO rows that match that join.
You know you need a join, that’s why you asked the question to start with.
My question to you is, what table in the original RDD holds the identifying fields that you can use to join to partbininfo so that you can return ONLY THE MATCHING ROW from your partbininfo table? What fields do you need to use so that you can join to the partbininfo table and only retrieve the matching row from the part bin info table that matches your transaction? I’ll give you a hint on the fields you’ll need. You need the company, the part number, the warehouse, and the bin.
So what table in your original RDD holds those very same field values that you can use to join onto PartBinInfo so that you only get 1 matching row for the bin you are transferring to?
Fine then.
I can’t anyway. I just wondered if ya’ll would be happy if I could.
Kevin, I just didn’t know whether I wanted to see the solution or not, at least not yet! 
Just trying to bring some levity in here.
2 Likes
Thanks for the explanation. Should I use the partbin table?
@atuljainajm, what fields would you need to select the right partbininfo row of the two that are listed for part 1005-03 for your STK-STK movement TO BIN?
Tell me the fields.
In these two photos, tell me the fields that identify the right record that you want.
Did you mean chose Warehouse and Bin and that would identify the location?
1 Like
You already know two of the fields and those are company and part number.