topic Re: Variable List for Multiply Names in QlikView

Variable List for Multiply Names

Anonymous — Thu, 29 Sep 2016 10:05:37 GMT

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

Re: Variable List for Multiply Names

sunny_talwar — Thu, 29 Sep 2016 16:03:52 GMT

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

Re: Variable List for Multiply Names

Anonymous — Thu, 29 Sep 2016 16:20:17 GMT

Thanks Sunny

This will help me tremendously

Kind Regards

Wendy

Re: Variable List for Multiply Names

Anonymous — Fri, 21 Oct 2016 06:50:07 GMT

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

Re: Variable List for Multiply Names

sunny_talwar — Fri, 21 Oct 2016 15:26:01 GMT

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,

Re: Variable List for Multiply Names

Anonymous — Fri, 21 Oct 2016 15:50:51 GMT

Hi Sunny,

Thanks I missed the obvious now it works perfectly.

Kind Regards

Wendy