Two field load block

Anonymous — Thu, 23 Aug 2018 03:39:32 GMT

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*');

Re: Two field load block

andrey_krylov — Fri, 24 Aug 2018 03:29:12 GMT

Try this

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

topic Re: Two field load block in App Development

Two field load block

Re: Two field load block