Discussion Board for collaboration related to Creating Analytics for QlikView.
i have a column and in that column i have some data like this
now i want if there is CO in starting then i want to rename as CO and if data has DF at starting then i want only DF in data like this
what should i do
View solution in original post
=Pick(WildMatch(Dim,'CO*', 'DF*'), 'CO','DF')