Look for values between blank rows

[Smilemaker]

Dear All,

I am new to Alteryx designer and as am getting a hands-on am enjoying and learning daily.  Need your support now.

I have attached the file i am working on.  The data is designed in such a way that there will be an empty row when there is a change in invoice date and amount. There is a column named ERP.  Now, i would need only those rows with same invoice date and amount but with both ERPs in it (basically the rows that have SAP and Tally in between the blank rows)

For example, i need only the rows such as from 118 to 121 and 150 to 151 which has same invoice date and amount and both the ERPs.

Your help and guidance will be highly appreciated

[grazitti_sapna]

Hi @Smilemaker , is this what you are looking for?

If this solves your purpose then mark this post as solution.

Thanks.

[Smilemaker]

Hi @grazitti_sapna thank you for your immediate response.

I just did a random check and found few lines were missing from the intended output.  Example below

My initial file had 7 invoice details from row number 474 to 480 however 2 rows (474 and 475) are missing in your output.  This is one that i randomly picked, not sure if there are more such cases.

[grazitti_sapna]

Hi @Smilemaker , check now.

Thanks.

[grazitti_sapna · Accepted solution]

@Smilemaker , try this alternate and easier way if this matches your desired output.

Try both ways and choose one suitable to your requirement.

Thanks.

[Smilemaker]

That is working awesome..... Thank you much Sapna!!