Hi all,
I'm building a workflow that involves chained analytic app and I realise that the problem im facing is the Contains Formula in the filter tool after the list box + action tool which updates the user input value in. I understand that if i used formula: [Index Cap] in ("XYZ"), the chained analytics app will work perfectly. However, in the case that I'm facing, I need the formula to find the user input value to a string field [Indexpattern] that contains more than just the user input, and the chained app will not flow the result in step 1 to step 2 and everything does not work.
I have attached the package here in hopes that someone can help me out w this situation! Thank you in advance.
Solved! Go to Solution.
Check the attached. Not quite sure what the second app is for, so I just changed how it worked on both.
Basically the user inputs data in the text input, then you split the values to rows in order to have 1 value for each row, finally you check if "any" of the values are within the IndexPattern field with a Find Replace tool. Let me know if this works for you.
@Podoseb0 i like your creative solution!
User | Count |
---|---|
53 | |
27 | |
26 | |
24 | |
21 |