Variable List for Multiply Names

[Anonymous]

Hi Everyone,

Just wondered if anyone could help me please.

I have a number of reports which I want to incorporate in my Qlik View Report.  The only problem I have is that all these reports show the Supplier Names in lots of different formats.  For example

Report 1	Report 2	Report 3	Report 4
Name 1234	NAME 1234	Name (1234)	NAME - 1234
Supplier One	Supplier1	Supplier 1	SUPPLIER ONE
No Name	NONAME	NO (Name)	No - Name

I was thinking that perhaps I could write a variable list which would take all these examples and bring back just my preferred name.

Does anybody have any idea how I would approach this?

Many Thanks

Kind Regards

Wendy

[sunny_talwar · Accepted solution]

I think you need to clean your data. May be look here for ways you can do this: Data Cleansing

[Anonymous]

Thanks Sunny

This will help me tremendously

Kind Regards

Wendy

[Anonymous]

Hi,

I followed the instructions in the link but I must be doing something wrong as it is not working.

Please see below part of my script.  Please could you advise why this would not work?

MapTable:

LOAD [Change From],

     [Change To]

FROM

[Mapping Table Names.xlsx]

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD

  ApplyMap( 'MapTable', [Repairer Name] ) as RepairerName,

Many Thanks,

Kind Regards

Wendy

[sunny_talwar]

Did you forget to add the Mapping keyword?

MapTable:

Mapping

LOAD [Change From],

    [Change To]

FROM

[Mapping Table Names.xlsx]

(ooxml, embedded labels, table is Sheet1);

Data:

LOAD

  ApplyMap( 'MapTable', [Repairer Name] ) as RepairerName,

[Anonymous]

Hi Sunny,

Thanks I missed the obvious now it works perfectly.

Kind Regards

Wendy