Dynamically filter out data based on a different input data

[madhurinani]

Hello,

I want to dynamically filter out certain keywords that I am getting based from a different input data.

In the above example, I am able to create the CALC column if there is only 1 condition of filtering out keyword C. I use the Contains logic to achieve that.

But now my requirement is that if I get an external file which has all the keywords that need to be filtered out, how do i achieve that?

So for example, since keywords C and D needs to be filtered, I need to create some formula that looks on group 1, filters our C&D and the new column should be 21-3-4==14

Group	Names	COUNT
1	A	1
1	B	2
1	C	3
1	D	4
1	E	5
1	F	6
1	TOTAL	21
2	B	4
2	C	5
2	E	6
2	F	7
2	TOTAL	22

Names

C

D

[binuacs · Accepted solution]

@madhurinani something like below

[Amol_Telore]

Hey @madhurinani 

One way of doing this. I was not clear about the desired results so I have added both the outputs in flow as per my understanding. Hope this is what you are looking for. Feel free to reach out to me in case of any concerns.

Output 1

Output 2

Regards,

Amol Telore

[Amol_Telore]

@binuacs beat me this time. 😁

[ChrisTX]

The attached workflow should give you a starting point.

Chris

[madhurinani]

Hello @binuacs ,

Thank you for your earlier solution.
There is an edge case which I noticed in my input data.

I have added one more record on the main dataset.

Row #13 is the new record which is added.
When I run the workflow, the group #3 data doesnt show up. I understand that #3 has no matching record or anything to compare with the other data source. But it should display the record as it is in the final output.

How can i achieve that?

I am also attaching your workflow in which i included the added record for your reference.

Thanks

[binuacs]

@madhurinani Adding a union tool to the left join output anchor will solve the issue