Data filter Slice with 3 column

[nishat786]

Hello Team,

I have my company data with employee information as [Name], [Phone], [Assign City], [Job Title],[Multiple Job Title] etc. In the [Assign City] column show in which city is employee is assigned. For the [Job Title] it shows what type of job he is assigned to. And for the [Multiple Job Title] the employee is also assigned to different job. 

[Assign City], (Enum) Example (Austin Slice)

[Job Title],(Enum) Example (HR)

[Multiple Job Title],(Enumlist) (which has multiple job title as enumlist)

Example (HR, Data Analyst, Teller, Online Specalist.

 I have created a slice for a [Assign City] by the city name which gives me a filter data with the city and the [Job Title] but I am not able to filter the [Multiple Job Title] data if that column has that [Job Title] 

Thank you for your time!

Best,

Nishat

[Kirk_Masden]

Could you give examples of titles and tell us exactly how you would like to filter them?  I take it that  [Multiple Job Title] is sometimes empty.  Would you like to include all records that have such-and-such title in either [Job Title] or  [Multiple Job Title] ?  If so, that should be easy enough but I need to know what you are trying to do.

[nishat786]

Yes that is correct, If Job title is Hr it should give me filter data from the Multiple title list that match with the job title.

Filter data based on job title

Thanks 

[Kirk_Masden]

Thanks but I'm still having difficulty understanding.  Let's say you wanted to select all of the records in which whatever is in [Job title] can also be found in [Multiple title].  I think that would be as follows:

IN([Job title],split([Multiple job title]," , "))

About IN():
https://support.google.com/appsheet/answer/10107681?hl=en

Why I used SPLIT():

The data is stored as follows in your Google sheet:

HR , Data Analyst , Teller , Online Specialist

Splitting everything by " , " makes a list of all of the items stored in the EnumList.  You need a "list" to use the IN() expression.

I don't know if this is what you wanted to do but perhaps this gives you an idea of how to approach the problem.

[nishat786]

Thank Kirk, The expression work well by it self.

IN([Job title],split([Multiple job title]," , "))

But when i try to use AND() with it. The list come empty 

AND(IN([Job title],split([Multiple job title]," , ")),[Assign City]="Austin")

[Kirk_Masden · Accepted solution]

Your express looks good to me.  If you use 

IN([Job title],split([Multiple job title]," , "))

as your condition, do some of the records have "Austin" in [Assign City]?  Or, if you use 

[Assign City]="Austin"

as your condition, do some of the results have a [Job title] that is also included in [Multiple job title]?

I think your expression looks good so the problem might be with your data.  I'd test each part of your and expression separately before putting them together to try to find the cause of the issue.