Text analytics - FilePathPattern to a value list

Have had a similar request a while back. My solution was to save the extracted value in a text property and then in the next step of a workflow to run a script that uses this text value in a search to find the corresponding lookup value and insert that in the lookup property.

It might be simpler for you to use Matcher if the documents do not contain a lot of dates. If they do, Matcher may provide false suggestions based on dates found in the document.

Have had a similar request a while back. My solution was to save the extracted value in a text property and then in the next step of a workflow to run a script that uses this text value in a search to find the corresponding lookup value and insert that in the lookup property.

It might be simpler for you to use Matcher if the documents do not contain a lot of dates. If they do, Matcher may provide false suggestions based on dates found in the document.

Hi, Thanks for the reply. 

So basically Text analytics cannot populate a value list property? 

I'm not sure I can use Matcher, because the date is coming from the file path, using Smart Migration (Sorry I missed this bit) that is why I'm using Text Analytics and regex.

Yeah, Matcher can only work with the document content so when working with file paths you need to use Text Analytics.

Thanks Joonas, 

Our M-Files Sales engineer confirmed the same. And Text Analytics cannot be used to populate a value list based property :(

We have come up with a dirty work around. I'm using Text Analytics to get the data we need and fill in a temporary text property (hidden from the metadata card) and then use PropertyCalculator to set the correct value in the value list based on the text in the hidden property. 

Maybe this might help someone else one day :)