Delete lines from Excel

I am new to Alteryx development. Appreciate every help that I get here.

Below are 2 excel tables. I need to locate the vendor no that is there in Duplicate Data, in the table, Triage Data. Once it is found,

I need to remove the particular row from the Duplicate Data and also the very next row and write it into another excel

In the below example,

Vendor 51AAT328 is present in Triage Data. Hence, I need to remove these lines from the Duplicate Data

RT7260	51AAT328
RT7260	1JJK0083

Similarly,

Vendor RTY116328 is present in Triage Data. Hence, I need to remove these lines from the duplicate data

TY7255	RTY116328
TY7255	YUOP000083

Kindly help

Duplicate Data

Duplicate Group	Vendor No.
RT7260	51AAT328
RT7260	1JJK0083
TY7255	RTY116328
TY7255	YUOP000083
UI7249	TYU143899
UI7249	UIO143899
IO7247	TTT000281
IO7247	QWE000281

Triage Data

Duplicate Group	Vendor No.
HJK758	51AAT328
14ER5U	0001008826
14RTY47	RTY116328
ERTY47	0001013556
15TYH0	TYU143899
14YUJ0	0001013556
1RFGT5	TTT000281
15RTFG5	0001030324

Developer

Developer Tools

Data Investigation

Accepted answers

All comments

Kallis

May I ask for someone to help?

caltang

@Kallis with that logic, everything wil be removed in Triage data.

You are saying, for whatever vendor no. that exists in Duplicate data - the same data in Triage file will also be removed in addition to its row + 1.

Can you confirm that?

caltang

Please find attached - hope this helps visualize the issue I mentioned.

For Bob2.yxmd

ed_hayter

I replied to your other thread with a way of doing this:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Extract-the-2nd-line-and-allocate-the-remaining/m-p/1205564#M299118

It would be useful to know what you are still having difficulty with in that thread rather than reposting.

Ive attached the workbook with your new fake input data

Export Grouped Reports.yxmd

Kallis

Thanks @caltang

Kallis

Hi @ed_hayter

Yes, I am new to Alteryx development. Infact, this is very first project ever. I wasn't able to understand all the tools that you had mentioned. Perhaps, I wasn't clear with my requirement. Hence, I posted a new thread with close to real-time data. Thanks for your solution though.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280