Discussion board where members can get started with QlikView.
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.
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/1464363https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/LoadData/data-cleansing....
View solution in original post
Thank you so much Colin
Based on Sample posted,
LOAD *,If(WildMatch(Field,'*Hospital*'),Upper(Left(Field,Len((Field))-9)),Upper(Field)) as Cleansed_FieldFROM[File Path]