5 Replies Latest reply: Aug 7, 2014 7:48 AM by Sheldon Braid

# Match Function with array of values

Trying to use the Match Function against an array of values. I have an array of time values in Field "HourArray". Next I wrote a calculated dimension using the Match Function. and named it "Working Y/N" in the pivot table. My intent is for the Match Function to find the match for the single digit hour in field "HourOfDay" in the array stored in field "HourArray" , and have the result returned as Working or Not Working in field "Working Y/N". The match always returns 0. I have tried removing the single quotes in the array to no avail. If anyone has some insight to this, it would be greatly appreciated.

Thanks All.

• ###### Re: Match Function with array of values

Hi Sheldon

-Matt

• ###### Re: Match Function with array of values

Trying to use the Match Function against an array of values. I have an array of time values in Field "HourArray". Next I wrote a calculated dimension using the Match Function. and named it "Working Y/N" in the pivot table. My intent is for the Match Function to find the match for the single digit hour in field "HourOfDay" in the array stored in field "HourArray" , and have the result returned as Working or Not Working in field "Working Y/N". The match always returns 0. I have tried removing the single quotes in the array to no avail. If anyone has some insight to this, it would be greatly appreciated. Thanks All.

• ###### Re: Match Function with array of values

Thanks! I updated the first post for you

• ###### Re: Re: Match Function with array of values

So i don't understand the format of the array, but if the array is actually just a field from the data model, a common way to do the same thing is with the CONCAT and substringcount function. Does this help ?

• ###### Re: Match Function with array of values

The SubString Count Function was exactly what was  needed! Thanks Jonathan!