Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you need to clean your data. May be look here for ways you can do this: Data Cleansing
I think you need to clean your data. May be look here for ways you can do this: Data Cleansing
Thanks Sunny
This will help me tremendously
Kind Regards
Wendy
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
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,
Hi Sunny,
Thanks I missed the obvious now it works perfectly.
Kind Regards
Wendy