2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Knock of entries to identify

Khanzali007
7 - Meteor

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.

6 REPLIES 6
IraWatt
15 - Aurora

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
8 - Asteroid

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
7 - Meteor

@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
7 - Meteor

Hi @Luke_C  this the one. 

Thanks in advance.

prashant007
7 - Meteor

good question

Labels