Forum Discussion

Helper II

4 years ago

Solved

update a column value from different tables

Hello everyone, AlexisOlson please help i have an issue i want to update the column values(Numero Agents) of my APE 02 2022 table Numero Agents DDS_X1_SPLIT DDS_CA_MPREM DDS_CA_Q...

General Comment

Tips and Tricks

4 years ago

Create a new column using:

New Numero Agent = 
LOOKUPVALUE('table *agents list*'[New Agents Codes],'table *agents list*'[EAAGENT], 'APE 02 2022 table'[Numero Agents])

Helper II

4 years ago

this is the expected data sample that i want to look like

EEAGENT has old values. New Agents Codes are the new ones

So i want to return New Agents Codes values

Numero Agents	DDS_X1_SPLIT	DDS_CA_MPREM	DDS_CA_QPREM	DDS_CA_SPREM	DDS_CA_APREM	APE per agents	New Numero Agents	Names
A99999009	0,5	20000	57332	111997	219160	120000	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A99999009	1	25000	71777	140333	274722	300000	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A99999009	0,5	30000	86222	168667	330279	180000	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A99999009	0,5	20100	57620	112563	220271	120600	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A99999009	0,5	20200	57911	113133	221388	121200	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A99999009	0,5	35000	100668	197002	385836	210000	A99901001	MOUAFFI SINDEU BRICE CEDRICK
A79999021	0,5	100000	288444	565333	1108055	600000	A79901001	ATSOL NDONGO NATHALIA
A79999021	0,5	100000	288445	565334	1108057	600000	A79901001	ATSOL NDONGO NATHALIA
A79999021	0,5	50000	144000	282000	552500	300000	A79901001	ATSOL NDONGO NATHALIA
A79999021	0,5	100000	288445	565334	1108057	600000	A79901001	ATSOL NDONGO NATHALIA
A79999021	0,5	50000	144000	282000	552501	300000	A79901001	ATSOL NDONGO NATHALIA
A79999021	0,5	50000	144000	282000	552501	300000	A79901001	ATSOL NDONGO NATHALIA
A99999009	0,5	20000	57333	111999	219165	120000	A79901001	ATSOL NDONGO NATHALIA

Community Champion

4 years ago

Create a new column using:

New Numero Agent = 
LOOKUPVALUE('table *agents list*'[New Agents Codes],'table *agents list*'[EAAGENT], 'APE 02 2022 table'[Numero Agents])