List box and filter not updated to the next Chained Analytics App

Question

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.

List Box Macro Demo JE data.yxzp

Podoseb0 · Accepted Answer

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.