Forum Discussion
Solved
Update table based on values from other table ?
Hello
I have a table A containing customer numbers and other columns (10000 + entries)
I have a table B containing customer numbers and one column containing a country code (10 rows)
How can I update one column of Table A with country codes coming from table B where customer codes are the same ?
Thanks
I have a table A containing customer numbers and other columns (10000 + entries)
I have a table B containing customer numbers and one column containing a country code (10 rows)
How can I update one column of Table A with country codes coming from table B where customer codes are the same ?
Thanks
Do you mean Update an exisitng column?
If the 2 tables are related, You can simply use RELATED(TableB[Country Codes)) to get CountryCodes in TableA
or use LOOKUPVALUE if they are not related
2 Replies
Do you mean Update an exisitng column?
If the 2 tables are related, You can simply use RELATED(TableB[Country Codes)) to get CountryCodes in TableA
or use LOOKUPVALUE if they are not related
- Yes i mean update only values of an existing column of table A where customer code is the same than in table B. Yes both tables are relate thanks to the customer nb Column existing in both tables.
