How to use WildMatch function here?

[#1]

Hi,

Here is the attached example Spreadsheet I need to get only from the field Channel = 40 and Division =AC and Partner =50.

Can anyone help me on this?

I tried the following in scrip but it is not working 😞

where wildmatch([Channel],[Division ],[Partner ], '*40*','*AC*','*50*');

[maxgro]

why wildmatch?

you can use a simple where Channel='40' and Division......

but if you want wildmatch, try

LOAD Component,

     Channel,

     Division,

     Partner

FROM

amouunt.xlsx

(ooxml, embedded labels, table is Sheet1)

Where WildMatch(Channel&'-'&Division&'-'&Partner, '40-AC-50')

[Ralf-Narfeldt · Accepted solution]

The load condition would be where Channel = 40 and Division = 'AC' and Partner = '50'

[#4]

Thanks a ton Ralf 🙂