Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
xyz1
Contributor III

?

.

11 Replies
Partner
Partner

Re: Mapping fields?

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
Contributor III

?

.

techvarun
Valued Contributor II

Re: Mapping fields?

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
Contributor III

?

.

Partner
Partner

Re: Mapping fields?

But you Know what correct fields against what party name.

Thanks,

Arvind Patil

techvarun
Valued Contributor II

Re: Mapping fields?

Is it possible to share the data here?

Thanks,

Varun

antoniotiman
Honored Contributor III

Re: Mapping fields?

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

Partner
Partner

Re: Mapping fields?

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
Contributor III

?

.