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.
