Formula on a field

[qlikviewaf]

Hi,

i would like to use this formula on my script, but i got an error saying "the field name should be unique".

How i can manage this in a afficient way?

Thanks

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc

[prma7799]

Try this

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc_New

[qlikviewaf]

I would like to mantain the same Field Name since all my app has been build using Country_desc

[prma7799]

You don't allow same name in one table ...

Either you can rename your old filed or new field like this

1....

Load

Country_Desc as Country_Desc_Old,

if(Match(trim([Code]),'ACT'),'Adjustment', Country_Desc) as Country_Desc

...

From ....

or

2...

Load

Country_Desc ,

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc_New

...

From ....

[stabben23]

Then you have to rename the Original Field, like Country_Desc as Country_Desc_Org. Or comment the Field away from script using //Country_Desc

[Anil_Babu_Samineni]

Perhaps this

Pick(Match(trim(

),'ACT')+1,'Adjustment', Country_Desc) as Country_Desc