How to filter multiple IDs | Experience Community
Skip to main content
Solved

How to filter multiple IDs

  • August 18, 2023
  • 1 reply
  • 458 views
J
Level 1 ●
Forum|alt.badge.img+1

I have a list of poor responses I need to delete from data & analysis tab and remove from quota (working with a panel provider). I have about 200 responses to delete. Is there a way to search for all 200 id’s at once?

Best answer by TusharDalwani

Hello Jemima, you can CONCATENATE those 200 response IDs (each separated by a comma) in Excel and then use that string using the “includes” operator to filter out those responses in data & analysis. This will allow you to delete just those 200 responses and decrement the quota as well.

    1 reply

    TusharDalwani
    QPN Level 6 ●●●●●●

    Hello Jemima, you can CONCATENATE those 200 response IDs (each separated by a comma) in Excel and then use that string using the “includes” operator to filter out those responses in data & analysis. This will allow you to delete just those 200 responses and decrement the quota as well.

    ~Tushar Dalwani
      Terms & ConditionsAccessibility statement