Two field load block

[Anonymous]

Can you help me correct my syntax in the bottom two lines? I only want to load records with Clinton and Bush from the Alumni field as well as Yale and Harvard from the School field.

LOAD

    Alumni,

    State,

    School,           

    Title

FROM [lib://Alumni.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where WildMatch([Alumni],'*Clinton*', '*Bush*',),

Where WildMatch([School],'*Yale*', '*Harvard*');

[andrey_krylov · Accepted solution]

Try this

Where WildMatch([Alumni],'*Clinton*', '*Bush*')  and WildMatch([School],'*Yale*', '*Harvard*');