Fields with same or similar names

[jedraskj]

Hi I am very new to Qlikview

I have imported a number of financial years data from excel and would like guidance on how to not have duplicate names eg Atherton and Atherton Hospital.  Ideally I would like Atherton only.

I don't want to have to clean the data in excel before moving into Clikview.  But will do if needed.

Hope someone can provide me with some tips.

[Colin-Albert · Accepted solution]

Have you looked at using mapping tables to cleanse your data when you load it into Qlik?

There are some tips here that may help. 
https://community.qlik.com/t5/Qlik-Design-Blog/Data-Cleansing/bc-p/1464363
https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/LoadData/data-cleansing....

[jedraskj]

Thank you so much Colin

[Vengatesh]

Based on Sample posted,

Try this

LOAD *,If(WildMatch(Field,'*Hospital*'),Upper(Left(Field,Len((Field))-9)),Upper(Field)) as Cleansed_Field
FROM
[File Path]