Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to replace company name to english charater ?

Hi All

I have a payment table , the company name is in thailand charater.

CUST_ID = E00091 , The company name display as ¡ÒÃä¿¿éÒ½èÒ¼ÅÔµáË觻ÃÐà·Èä·Â ÊÒ¢Ò 00002

May i know how to replace as below :-

CUST_ID = E00091 , the company is IBCON LTD

Hope some one can advise me.

1 Solution

Accepted Solutions
Employee
Employee

Re: How to replace company name to english charater ?

Here is a generic example on the setup. Basically you just load two fields from an Excel file. The first filed is the From value and the second field is the To value.

Notice that the script has two examples, depending on if you want to do a case sensitive match or not.

7 Replies
Not applicable

Re: How to replace company name to english charater ?

i enclose the qvd file,

Employee
Employee

Re: How to replace company name to english charater ?

I would try a mapping table approach. Basically set up a two column table with the old and new values, then use apply map to cleanse your data during load.

MapCompanyName:

Mapping LOAD * Inline [

From , To

¡ÒÃä¿¿éÒ½èÒ¼ÅÔµáË觻ÃÐà·Èä·Â ÊÒ¢Ò 00002, IBCON LTD

];

MyData:

LOAD

  ApplyMap('MapCompanyName', MyCompanyName, MyCompanyName) AS MyCompanyName

From MySource

Not applicable

Re: How to replace company name to english charater ?

Hi Toni,

thank you for your reply,

How if the name of the company that need to be changed more than one (eg. 100 companies)?

Employee
Employee

Re: How to replace company name to english charater ?

In the mapping table you simple list all mapping combination. I often do the actual conversion table in an excel sheet and then load it as a mapping table, this way it is a bit easier to maintain compared to an inline table.

Did that answer your question?

Not applicable

Re: How to replace company name to english charater ?

yes, it did. but I have not learn the mapping  using an excel file. Could you teach me how to mapping with excel file.

I attach qvd file that you suggest (with mapping).

Employee
Employee

Re: How to replace company name to english charater ?

Here is a generic example on the setup. Basically you just load two fields from an Excel file. The first filed is the From value and the second field is the To value.

Notice that the script has two examples, depending on if you want to do a case sensitive match or not.

Not applicable

Re: How to replace company name to english charater ?

Hi  Toni,

Thank you, it's very helpfull for me.

Best Regards,

Ted