Hi All, Can anyone help me with this scenario? I have one input as a database, below is its format. I have some filter conditions to get data. I need to create multiple flows in one canvas based on filter conditions and get multiple outputs. Each condition can vary on different columns of input with 'and' and 'or' conditions and in the output, I need 3 columns - Eid (from input ), Category, Code (created in the canvas based on conditions defined), Required: I need to create an optimized alteryx solution where I can have all the columns of the input and every time a new condition is given, I just need to add 'AND' and 'OR' conditions to those particular columns mentioned in the condition and generates a new output of 3 columns (Eid, Category, Code) in the same canvas in which Category and code are generated during the flow as per the condition. Hardcode values will be given for Category and Code in every defined condition. Example : Input sample EidProcess_dateDeptAssigned_teamLocationSal_currencyBase_locationUnitManager_NameDays120-07-2022AAAZCADZZavhjAB1221-07-2022BBBYINRYYyahjVBF2322-07-2022BCCXJPYTTavhHG3423-07-2022DDDWUSDWWkgsSJ45 24-07-2022EEEVCADVVnjhAJ5 Let's say I have condition 1 for 1st flow - Dept =A and sal= CAD then category = 'def' and code ='11' Output - Output should be EidCategorycode1def11 Condition 2 : Dept=B and (assigned_team = bb or cc) and (unit = YY or TT) then category = 'GHI' and code ='22' the output should be ; EidCategorycode2GHI223GHI22 Condition may use any string functions on any column. Here I have given two conditions only but there'll be around 100 so I need an optimised and automated data driven solution for this so that every time a condition is given, I have to just add 'AND' and 'OR' conditions to the particular columns and less of manual work. If anyone can help, Thanks in advance.

Dynamic solution to filter data on basis of multiple conditions and get multiple outputs

Hi All,

Can anyone help me with this scenario?

I have one input as a database, below is its format. I have some filter conditions to get data.

I need to create multiple flows in one canvas based on filter conditions and get multiple outputs.

Each condition can vary on different columns of input with 'and' and 'or' conditions and in the output, I need 3 columns - Eid (from input ), Category, Code (created in the canvas based on conditions defined),

Required: I need to create an optimized alteryx solution where I can have all the columns of the input and every time a new condition is given, I just need to add 'AND' and 'OR' conditions to those particular columns mentioned in the condition and generates a new output of 3 columns (Eid, Category, Code) in the same canvas in which Category and code are generated during the flow as per the condition. Hardcode values will be given for Category and Code in every defined condition.

Example :

Input sample

Eid	Process_date	Dept	Assigned_team	Location	Sal_currency	Base_location	Unit	Manager_Name	Days
1	20-07-2022	A	AA	Z	CAD	ZZ	avhj	AB	1
2	21-07-2022	B	BB	Y	INR	YY	yahj	VBF	2
3	22-07-2022	B	CC	X	JPY	TT	avh	HG	3
4	23-07-2022	D	DD	W	USD	WW	kgs	SJ	4
5	24-07-2022	E	EE	V	CAD	VV	njh	AJ	5

Let's say I have condition 1 for 1st flow -

Dept =A and sal= CAD then category = 'def' and code ='11'

Output - Output should be

Eid	Category	code
1	def	11

Condition 2 :

Dept=B and (assigned_team = bb or cc) and (unit = YY or TT) then category = 'GHI' and code ='22'

the output should be ;

Eid	Category	code
2	GHI	22
3	GHI	22

Condition may use any string functions on any column.

Here I have given two conditions only but there'll be around 100 so I need an optimised and automated data driven solution for this so that every time a condition is given, I have to just add 'AND' and 'OR' conditions to the particular columns and less of manual work.

If anyone can help, Thanks in advance.

Workflow

Developer

Gallery

Input

Output

Tips and Tricks

Help

Dynamic Processing

Join

Data Investigation

Accepted answers

FilipR

OK, I have something for you after all. 😀

You have to compose your list of Filter conditions and the results in a Text Input like this:

Then you connect your input together with the list to the macro I created for you:

The results:

Filter by List of Conditions.yxzp

All comments

FilipR

EDIT: I didn't read the part about 100 conditions before answering, sorry.

Radhika

Thanks FilipR for solution but yes, I need a dynamic solution to this where I will have to just add logic for particular columns whenever a new condition is given

FilipR

OK, I have something for you after all. 😀

You have to compose your list of Filter conditions and the results in a Text Input like this:

Then you connect your input together with the list to the macro I created for you:

The results:

Filter by List of Conditions.yxzp

Radhika

Hi FilipR, Thanks a lot for the solution.

I am implementing the same on the real data its not giving output though te records are flowing accordingly but not getting output after macro and everything is fine until macro's output.

Is there anything which I need to know, Also just to understand what does 1=1 represents in the filter?

FilipR

@Radhika, if you are not getting any output, then most likely the conditions you put in the indicated field are invalid. Please check your syntaxes and test if they work if you put them in a regular Filter tool.

The 1=1 is just a placeholder. The macro replaces it with whatever you put in the Conditions field.

Radhika

@FilipR is there any data-specific condition that you have applied here in macro (either in filter or formula) because, in macro, data is not getting joined as per my data because cond=0 and recordid=1, and there is no output then?

FilipR

@Radhika please give me an example where it does not work for you so I could test for myself.

The macro is plug and play. You don't change anything inside of it. It will return rows if they meet the conditions you feed into it. It will not return a row if it does not meet any conditions.

Radhika

Done. Thanks for the help.

FilipR

@Radhika I am not sure where do you have problems then. The macro goes row by row. Having a column with a unique ID is not required. Only the conditions you put in the Text Input have to make sense and need to follow the right syntax.

I provided you with a working example based on the data and conditions you provided.

Please mark my post as a solution.

Radhika

@FilipR do you have any alternate solution bcz even if I am creating it from scratch with the same inputs and everything same, as used by you it's not giving me results, there are no output records. I am new to alteryx. I have checked all the configurations with the one you have created and using the same inputs but no output. So if you have any alternative or any setting which I should be aware of or if you can elaborate it and check if you provided the correct workflow and macro.

FilipR

@Radhika Try putting your real data into the Text Input tool it in the workflow I attached. See if it works. Then check the conditions you are putting in the other tool.

Since my example works, your real data should work as well, unless you're doing something wrong somewhere along the way.

ChrisTX

@Radhika trying to test/debug a macro, especially as a beginner, can be challenging.

These two options are helpful to debug macros:

1) Designer > View > Interface Designer > Test View (the magic wand icon on the left hand side) > input your values > Open Debug.
This will create a new standard workflow with the actual values coming from your inputs.
A copy of the workflow will open called Debug Workflow# (# being some number)
You can use the Debug mode to test what values are passed from the app interface to the workflow
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Random-results-while-renaming-fields/td-p/503551

To use the debug feature, open the Interface Designer (Views > Interface Designer) and select the Test View (the Magic Wand icon on the left). Fill out the information requested by your app or macro, then click on Open Debug. A debug workflow will open as a new tab in your current Alteryx session. Run the debug workflow to make sure it is creating your desired results.

2) Community > Blogs > Engine Works Blog > The X-Ray Browse: Macro Debugging Made Easier
Designed primarily for developing & debugging macros, the X-Ray Browse enables you to pick a location within a macro under development, to view the data passing through said macro at said location. The effect is similar to a Browse tool, but the data is made viewable through the encapsulating "skin" of the macro being developed.
https://community.alteryx.com/t5/Engine-Works-Blog/The-X-Ray-Browse-Macro-Debugging-Made-Easier/ba-p/2358
Gallery Download link for X-Ray Browse Macro: https://gallery.alteryx.com/#!app/X-Ray-Browse-Macro/546263f9398a7111307b0cdc

Also try: workflow configuration option (checkbox) for "Show All Macro Messages"

Also see:

Debugging Alteryx Analytic Apps

https://www.altertricks.com/how-to/debugging-alteryx-analytic-apps/

Chris

Arvinchester

Hi FilipR,

Do you have the macro file that you used here?

FilipR

@Arvinchester it should be inside the yxzp I posted.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703