Need one help

[nagarjuna_kotha]

Hi all,

I have one Field   "Code_Type" , in that i have a value 10.But what i want is instead of 10 i want "Country".Can any one help me how to get that ?

thanks in Advance

Naga

[arulsettu · Accepted solution]

like this

[#3]

Hi

Try like below,

LOAD Code_Type,

     Name,

     if(wildmatch(Country,'10'),'Country') as NewCountry

[jagan]

Hi,

Change your script below, now country values are displaying in the Code_Type field.

LOAD Country AS Code_Type,

     Name,

     Country

FROM

(ooxml, embedded labels, table is Sheet1);

[qlikviewwizard]

Hi,

Please check this.

Hope this will help you.

Country:

LOAD * ,

if(wildmatch(Code_Type,'10'),Country) as Country_New;

LOAD Code_Type,

     Country,

     Name

FROM

[Country_NeedHelp.xls]

(biff, embedded labels, table is Sheet1$);

[jagan]

Hi Arul,

It is not a good practice to use calculated expression in List boxes, arrive a new column in script like below otherwise you will have performance issues or you need to hardcode in multiple places, it is difficult to maintain the changes in multiple places.

LOAD

*,

if(Code_Type='10','Country') AS NewFieldName

FROM DataSource;

Regards,

Jagan.

[arulsettu]

you are right Jagan

Thanks for the information