topic Re: Remove or Flag offset entry in Alteryx Designer Desktop Discussions

Remove or Flag offset entry

ManuelRodrigues — Wed, 09 Mar 2022 13:47:19 GMT

Hi All,

I have attached data inputs and was wondering is there a way i can use the multi row formula to flag that row 19 and 20 are offsetting entries and therefore i can then attach a filter on the other end and exclude them from the data population?

Re: Remove or Flag offset entry

atcodedog05 — Wed, 09 Mar 2022 13:48:34 GMT

Hi @ManuelRodrigues

What's the logic behind it?

Re: Remove or Flag offset entry

ManuelRodrigues — Wed, 09 Mar 2022 14:01:53 GMT

@atcodedog05 if travel claim start date, Destination/Location and Originating city are the same however if paid fare inc tax has an opposing negative entry then these two lines should be flagged to be removed.

Re: Remove or Flag offset entry

atcodedog05 — Wed, 09 Mar 2022 14:08:53 GMT

Hi @ManuelRodrigues

Here is how you can do it.

Workflow:

Hope this helps : )