Knock of entries to identify

[Khanzali007]

Hello,

I'm working on an Alteryx workflow and currently need some guidance.

I am trying to identify the knock off entries from a dataset in Alteryx. It will be >1M records. As currently i have attached sample data of 25K records.

To Knock off simple basic criteria is to knock off the amount with in Same PC (Column D)

Every amount wont be same as full like -100,000 & +100,000, it will be in any split form of 100,000.

For Example:

Refer column F for knock off, which is identified manual and rest as shown as Open.

Thank you in advance.

[IraWatt]

Hey @Khanzali007,

I'm not sure I understand what your trying to achieve. Would you be able to give a simple example of an input and desired output? 

[soccertil1108]

I agree with @IraWatt ... more details are required. I looked at your data and I believe that your first step would be to split the data into 2 data flows, one for "open" and the other for "clearing". Then you'll need to manipulate the data so that you can then join the two streams together. Finally perform the final calculation. When I looked at your data, I split the stream and then summarized both streams by PC. The summarization totals for all PC "clearing" rows became Zero (0). So I'm at a loss of how to process and join your data set to get the information you require.

[Khanzali007]

@IraWatt @soccertil1108  Thanks for your reply.

Sorry for not giving the info with details.

@soccertil1108 your understanding  is so close, but last column was result column which we have worked manual to identify contra entries, which is expected output from Alteryx.

For details information i have attached a excel file with explanation & examples Case 1 & Case 2.

Thanks in advance.

[Khanzali007]

Hi @Luke_C  this the one. 

Thanks in advance.

[Luke_C]

Hi @Khanzali007 

Maybe take a look at these posts for some inspiration, seems like a similar use case:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Removing-Netting-Entries/td-p/421072

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Netting-off-Transactions/td-p/799345

[prashant007]

good question

[Khanzali007]

Hi any one can help ? 

Expertise in same topic who have answered earlier question @Thableaus  @atcodedog05  Please help!

Especially on case 2. Attached sample file with example & cases.

Thanks in advance.