Grouping data within a list prior to loading

[#1]

Hi,

I'm new to QlikView and hoping someone might be able to help. I have a list "Booking Status" that has multiple Confirmation and Cancellation types, and I'm trying to simply the list and group all the different confirmation types as 'Confirmed' and same with 'Cancelled' through the script.

I've used If ([Booking Status]='Confirmed' or [Booking Status]='Confirmed Do Not Move' or [Booking Status]='Confirmed Internal' or [Booking Status]='Confirmed Web Reservation','Confirmed', [Booking Status]) as [Booking Status],

What syntax can I use to do the same for all cancellation types in the same list Booking Status?

[sunny_talwar · Accepted solution]

May be this

If(WildMatch([Booking Status], 'Confirmed*'),'Confirmed', 'Cancelled') as [Booking Status],

[#3]

Thank you so much for the quick suggestion!