We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Locate a value in one excel in another excel

Kallis
8 - Asteroid

Hi, I am new to Alteryx development. I would like to request for help.

 

Below are 2 excel tables. I need to locate the vendor no that is there in FP Data, in the excel, Triage Data. Once it is found, I need to remove the particular row from the FP Data and write it into another excel. Please let me know how can I prepare the workflow

 

 

TRIAGE DATA

 

Duplicate GroupDivisionVendor No.VendorInternal Ref.Invoice No.
1Div 120000Vendor 1Ref 1Invoice 1
2Div230000Vendor 2Ref 1Invoice 2
3Div340000Vendor 3Ref 1Invoice 3
4Div450000Vendor 4Ref 1Invoice 3
5Div 155000Vendor 5Ref 1Invoice 3
6Div234000Vendor 6Ref 1Invoice 3
7Div353000Vendor 7Ref 1Invoice 3
8Div412000Vendor 8Ref 1Invoice 3
9Div 111000Vendor 9Ref 1Invoice 3
10Div229000Vendor 10Ref 1Invoice 3
11Div356000Vendor 11Ref 1Invoice 3
12Div477000Vendor 12Ref 1Invoice 3
13Div 145000Vendor 34Ref 1Invoice 3
14Div233000Vendor 66Ref 1Invoice 3
15Div336000Vendor 76Ref 1Invoice 3

 

FP DATA

 

RiskSystemDivisionVendor No.VendorInternal Ref.Invoice No.
HighSys1Division 120000Vendor 1Ref 1Invoice 1
Highsys2Divison 230000Vendor 2Ref 1Invoice 2
HighSys1Division 340000Vendor 3Ref 1Invoice 3
Highsys2Division 450000Vendor 4Ref 1Invoice 3
HighSys1Division 555000Vendor 5Ref 1Invoice 3
Highsys2Division 534000Vendor 6Ref 1Invoice 3
HighSys1Division 653000Vendor 6Ref 1Invoice 3
Highsys2Division 712000Vendor 8Ref 1Invoice 3
HighSys1Division 711000Vendor 9Ref 1Invoice 3
Highsys2Division 829000Vendor 10Ref 1Invoice 3
HighSys1Division 856000Vendor 11Ref 1Invoice 3
Highsys2Division 977000Vendor 12Ref 1Invoice 3
Highsys5Division 1045000Vendor  12Ref 1Invoice 3
Highsys8Division 1133000Vendor 14Ref 1Invoice 3
Highsys9Division 1236000Vendor 88Ref 1

Invoice 3

 

      

 

10 REPLIES 10
Kallis
8 - Asteroid

Thanks Caltang. It really helps. 

Labels
Top Solution Authors