Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Filtering for Multiple Items in the Load statment

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.

4 Replies
YoussefBelloum
Champion
Champion

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
Champion
Champion

did it works for you ?

akuttler
Creator
Creator
Author

Yes it works. THanks!

YoussefBelloum
Champion
Champion

you're welcome

you can close the thread by marking correct answer as correct