Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
jedraskj
New Contributor

Fields with same or similar names

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.

1 Solution

Accepted Solutions
Highlighted

Re: Fields with same or similar names

3 Replies
Highlighted

Re: Fields with same or similar names

Highlighted
jedraskj
New Contributor

Re: Fields with same or similar names

Thank you so much Colin

Highlighted
Partner
Partner

Re: Fields with same or similar names

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]

You Know What To Do.