0

I would like to replace values in a columns from corresponding values in another table avoiding merging and expanding columns.

Data which I want to send to another table:

Table where I want to replace data:

As you can see I have 2 tables but they have different formatting, plus this 1st table (OQC) have some the same columns as 2nd table (result)

So I would like to replace this data from 2nd table by this data from 1st table.

Wai Ha Lee
  • 8,598
  • 83
  • 57
  • 92
Mateusz
  • 1
  • why do you not want to merge? – Gangula Oct 12 '21 at 11:08
  • Its 2 reports of some automotive parts. This table (OQC) is report after verify some of the parts in column result we have 2 options OK/NG some of this parts after verify was bad or good and this need change status e.g OK to NG with rest of the columns like "type of defect" and so on. – Mateusz Oct 12 '21 at 11:21
  • It is unclear what columns you want to put where, or why you want to avoid major functions like merge. Please provide a sample of before/after data – horseyride Oct 12 '21 at 11:22
  • https://i.imgur.com/eMjMznr.png – Mateusz Oct 12 '21 at 11:31
  • Agree, this is a textbook merge. You merge based on your common ID (LOT ID), expand the new col, delete the old col, rename the new col if needed. done. BTW, I noticed you duplicate your function, you should parametrize it instead. – ceci Oct 12 '21 at 11:32
  • I have already done it, it turned out that I did not know about the existence of the option to merge the query haha – Mateusz Oct 12 '21 at 11:53

0 Answers0