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 up...
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
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.