Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
virenjoshi
Contributor
Contributor

Pick(Wildmatch) not working

I am using the following expression in the filter pane to list five items in the dropdown. But it only shows 1st, 3rd and 5th item. Can anyone help me understand why it is not showing all the items in the dropdown?

=Pick(Wildmatch([DATACOLUMN],'*ON*','*FR*','*AB*','*QC*','*EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')

Labels (1)
1 Reply
Thiago_Justen_

What about this?

=Pick(Wildmatch([DATACOLUMN],'ON*','FR*','AL*','QU*','EN*'),'ONTARIO','FRENCH','ALBERTA','QUEBEC','ENGLISH')

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago