Filtering for Multiple Items in the Load statment

[akuttler]

Hello I am trying to filter for multiple items  in my load statement.

I've tried Where Exists & Where IN and it doesn't accept either...

LOAD

    "Date of AR Run",

    "Practice Name",

    "Insurance Name",

    "IB 30",

    "IB 31 to 60",

    "IB 61 to 90",

    "IB 91 to 120",

    "IB Over 121",

    "Total IB",

    PAYER_GROUP

FROM [lib://DATAMART BACKUP/INSAGINGDETAIL_2017.csv]

(txt, utf8, embedded labels, delimiter is ',', msq)

WHERE Exists("Practice Name", 'Derm 1', 'Derm 2', 'Derm 3')

Thanks in advance.

[YoussefBelloum]

Hi,

LOAD

    "Date of AR Run",

    "Practice Name",

    "Insurance Name",

    "IB 30",

    "IB 31 to 60",

    "IB 61 to 90",

    "IB 91 to 120",

    "IB Over 121",

    "Total IB",

    PAYER_GROUP

FROM [lib://DATAMART BACKUP/INSAGINGDETAIL_2017.csv]

(txt, utf8, embedded labels, delimiter is ',', msq)

WHERE Match("Practice Name", 'Derm 1', 'Derm 2', 'Derm 3')

[YoussefBelloum]

did it works for you ?

[akuttler]

Yes it works. THanks!

[YoussefBelloum]

you're welcome

you can close the thread by marking correct answer as correct