Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

11 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

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




xyz1
Creator III
Creator III
Author

.

techvarun
Specialist II
Specialist II

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

xyz1
Creator III
Creator III
Author

.

arvind_patil
Partner - Specialist III
Partner - Specialist III

But you Know what correct fields against what party name.

Thanks,

Arvind Patil

techvarun
Specialist II
Specialist II

Is it possible to share the data here?

Thanks,

Varun

antoniotiman
Master III
Master III

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

arvind_patil
Partner - Specialist III
Partner - Specialist III

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

xyz1
Creator III
Creator III
Author

.