Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
like this
like this
Hi
Try like below,
LOAD Code_Type,
Name,
if(wildmatch(Country,'10'),'Country') as NewCountry
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);
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$);
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.
you are right Jagan
Thanks for the information