82516_en-US

liliconcom

Join / Update Main Table with a Pick List Table

Situation: Our pick list system is a very manual process. A pick list is generated via an access query against our test database which i don't have access to because another group is responsible for. So i have to ask that group to export the generated pick list to a .csv file. I have to create a master pick list that includes everything. I am embarrassed to post this because i am sure that it is a simple join/update of which for the life of me, can't figure out. I need the update the Main Table with the Query Table replacing Bin 0's with Bin 1's. I have tried multiple types of Join Table and multiple Update Table from the drop down menu and I can't get it to what i need. I have attached both the Main Table and Query Table. Again, any and all help is greatly appreciated.

 

For some reason when i try to attach the tables i am getting an error "The contents of the attachment doesn't match its file type" so best i can do is the csv files

 

Main Table:

Bin 99 = dead space where no devices exist

Bin 0 = all possible device locations

 

Query Table [Pick List]

Bin 1 = all passing devices on the wafer

Re: Join / Update Main Table with a Pick List TableThank you Mr. Nelson.. I did so many combinations but not all of them.. I stuck to mostly the row and columns and kept getting crazy numbersRe: Join / Update Main Table with a Pick List Table

Here is a script that works with your example data tables.....it just required the matching based upon the correct combination of columns

Data Table( "A307 _ ALL" ) << Update(
 With( Data Table( "A307 _ QUERY" ) ),
 Match Columns(
  :lot_number = :lot_number,
  :part_number = :part_number,
  :row = :row,
  :col = :col,
  :subrow = :subrow,
  :subcol = :subcol
 )
)

Pre Distribution:

Distribution Post Update

Re: Join / Update Main Table with a Pick List Table

Try again.. Wow that was painful.. I put both the tables in the zip file..

 

Thank You

Re: Join / Update Main Table with a Pick List Table

Cut and Paste a sample from the files into an "Insert Code" object 

name age sex height weight
KATIE 12 F 59 95
LOUISE 12 F 61 123
JANE 12 F 55 74
JACLYN 12 F 66 145
LILLIE 12 F 52 64
TIM 12 M 60 84
JAMES 12 M 61 128
ROBERT 12 M 51 79
BARBARA 13 F 60 112
ALICE 13 F 61 107
SUSAN 13 F 56 67

Re: Join / Update Main Table with a Pick List Table

I think it might be our security when uploading files.. I would rather do the JMP table but i am getting an error as stated in my post.. Any suggestions?

---

@txnelson wrote:
The attached csv file is empty

---

 

Re: Join / Update Main Table with a Pick List TableThe attached csv file is empty