topic ? in QlikView

?

xyz1 — Sun, 14 Apr 2019 15:26:03 GMT

Re: Mapping fields?

arvind_patil — Tue, 01 Aug 2017 06:36:06 GMT

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 — Sun, 14 Apr 2019 15:27:07 GMT

Re: Mapping fields?

techvarun — Tue, 01 Aug 2017 06:44:17 GMT

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 — Sun, 14 Apr 2019 15:27:36 GMT

Re: Mapping fields?

arvind_patil — Tue, 01 Aug 2017 07:19:33 GMT

But you Know what correct fields against what party name.

Thanks,

Arvind Patil

Re: Mapping fields?

techvarun — Tue, 01 Aug 2017 07:20:46 GMT

Is it possible to share the data here?

Thanks,

Varun

Re: Mapping fields?

antoniotiman — Tue, 01 Aug 2017 07:44:43 GMT

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

Re: Mapping fields?

arvind_patil — Tue, 01 Aug 2017 08:04:32 GMT

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 — Sun, 14 Apr 2019 15:29:30 GMT

Re: Mapping fields?

antoniotiman — Tue, 01 Aug 2017 09:07:15 GMT

You can't.

Re: Mapping fields?

techvarun — Tue, 01 Aug 2017 09:25:27 GMT

Hi,

Please find the below output.

Master:

LOAD * INLINE [

factory, party_name, city, state, region, country, continent

G, a, SALEM, GUJARAT, WEST, INDIA, ASIA

G, b, COMMON, KARNATAKA, SOUTH, INDIA, ASIA

G, c, BANGALORE, DELHI, SOUTH, INDIA, ASIA

G, d, AHMEDABAD, GUJARAT, SOUTH, INDIA, ASIA

G, e, DELHI, COMMON, SOUTH, INDIA, EUROPE

G, f, BANGALORE, KARNATAKA, SOUTH, INDIA, ASIA

G, g, BANGALORE, KARNATAKA, SOUTH, INDIA, ASIA

];

Master1:

NoConcatenate LOAD factory,party_name,region,country,

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 Resident Master;

DROP TABLE Master

This may be a fix as of now. but the permanent fix is to create a master table and Implement Left join or Applymap in it.

still i can see Salem is tagged to Gujarat instead of Ahmadabad. and we cannot assume that either the state or city has a wrong mapping unless and untill we have a Master table(or File)

Thanks,

Varun.