topic Re: HELP--update function not bringing all values over despite 100% certainty I am matching in Discussions

HELP--update function not bringing all values over despite 100% certainty I am matching

plfazeli — Sat, 10 Jun 2023 23:44:33 GMT

Hi--I am very familiar with the UPDATE function and use is often. I am trying to bring over a column of data from a new set into my master set. Both datsets have the SAME subject IDs (and same amount, N=110 in both). When I update, it only brings over 52 of the values. The rest are missing and I am absolutely stumped because I know I used update correctly and matched correctly

Re: HELP--update function not bringing all values over despite 100% certainty I am matching

jthi — Tue, 22 Feb 2022 17:30:06 GMT

Without seeing the data I can only offer some guesses and suggestions.

You could try using Join (and possibly use full join also) to see what happens with that. Also you could order columns by the ID column in both tables, copy values over from one table to other into a new column and use some simple comparison formula to check that all values are same. Are both columns exactly same data/modeling type/format?

Re: HELP--update function not bringing all values over despite 100% certainty I am matching

txnelson — Tue, 22 Feb 2022 17:31:15 GMT

You are not providing sufficient information for debugging, What I suggest doing is to JOIN the data, not UPDATE and in the JOIN select the options to allow non matching records from both tables to be in the new data table. Also select the option to create a Match Flag variable. You will then see what records are not matching, and therefore not being brought across in your UPDATE

Re: HELP--update function not bringing all values over despite 100% certainty I am matching

pmroz — Wed, 23 Feb 2022 18:12:35 GMT

I recently had a similar puzzling problem with update. Turns out some of my match column values had leading spaces. Check for leading and trailing spaces/tabs/etc.