Hi! Quick question (with hopefully a quick answer). I've a dataset with multiple rows. Each row does have - let's say - 41 columns of which column 1 is a unique identifier, the next 20 columns are customer characteristics and the next 20 columns are the same as the 20 columns before (same names but with a fixed prefix) and could contain - per column - a different value. I'm looking for a smart way to compare the value of each of the 20 columns with the value of the same column with the same name (but now with a prefix). In case the value is the same, nothing should happen. In case the value is different, the column should be updated with the value from the column with the same name but the fixed prefix. I would like to prevent something as the below for each column: if REGIO ne XXX_REGIO then REGIO = XXX_REGIO;
if GESLACHT ne XXX_GESLACHT then GESLACHT = XXX_GESLACHT;
if VOORLETTERS ne XXX_VOORLETTERS then VOORLETTERS = XXX_VOORLETTERS Example of the dataset with a limited number of columns: ACCOUNTNUMBER REGIO GESLACHT VOORLETTERS XXX_REGIO XXX_GESLACHT XXX_VOORLETTERS 1 A 1 R.H.M. B 1 R.H.L. 2 A 2 D.A. A 1 D.A. 3 B 1 A. A 2 A. 4 A 1 S.B.M.J. A 1 S.B.M.K. 5 A 2 L.W. B 1 L.W. How could this be done? Thanks in advance! Regards, Sven
... View more