HI,
From the attached ITR_ALteryx file, from the tab " Account Mapping" , I would like to filter column " TM1 Category" and then select/filter from the TM1 category relevant items. How do I do that ?
At the moment I have use the filter but included as " Contains" .. that may miss some of the accounts.
Solved! Go to Solution.
You mean you want to make it into an Analytic App? The drop-down selection comes from having the user selecting it?
H, Yes wanted user to select the relevant category when the reconciliation is prepared. How do I do that?
Regards
Thiviya
Here's some reading material:
I've attached an example for you to learn.
To select multiple, you need a List Box interface tool rather than a Drop Down interface tool.
Make sure to change your Filter tool's expression accordingly to have a statement like:
[YourFieldHere] IN ("ToReplace")
Then the action tool should configure to:
For further reading:
That's because of this:
Your reference file must only have two fields: NAME and VALUE
Since you didn't export your package over, do you mind exporting your Alteryx workflow?
To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy. Please also export C:\Users\PATHMT\OneDrive - Pacific National\ITR\Alteryx\ITR_FS mapping drop down.yxdb