Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
HI Agrim,
I hope you Have Party Name wise Correct data in following way:
Party Name Correct City Correct State
So Use apply Map Two Times As Below:
CityMapping:
Mapping Load
[Party ID],
[Correct City ]
From <Path>
StateMapping:
Mapping Load
[Party ID],
[Correct State ]
From <Path>
Use apply Map into your base table two times one for city and one for state
ApplyMap('CityMapping','[Party ID]',City) as CorrectCity,
ApplyMap('StateMapping','[Party ID]',State) as CorrectState
Thanks,
Arvind Patil
.
If(State ='KARNATAKA', 'BANGALORE',If(State ='DELHI', 'DELHI', City)) as City,
If(City ='DELHI', 'DELHI', State) as State,
If(City ='DELHI', 'ASIA', Continent) as Continent
.
But you Know what correct fields against what party name.
Thanks,
Arvind Patil
Is it possible to share the data here?
Thanks,
Varun
Hi Agrim,
You can use DynamicUpdateCommand in Macro like this
Sub Update
SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE Table SET city = 'BANGALORE' WHERE factory='G' and party_name='b' ")
End Sub
This Macro works in Ajax Mode as well.
You can link this Trigger on OnOpen Doc or Botton Action.
See Attachment
Regards,
Antonio
HI Agrm,
You must create Master according to your party name wise which you want to select manually.
Party Name City State
and apply as i mentioned above.
Thanks,
Arvind Patil
.