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 Group | Division | Vendor No. | Vendor | Internal Ref. | Invoice No. |
1 | Div 1 | 20000 | Vendor 1 | Ref 1 | Invoice 1 |
2 | Div2 | 30000 | Vendor 2 | Ref 1 | Invoice 2 |
3 | Div3 | 40000 | Vendor 3 | Ref 1 | Invoice 3 |
4 | Div4 | 50000 | Vendor 4 | Ref 1 | Invoice 3 |
5 | Div 1 | 55000 | Vendor 5 | Ref 1 | Invoice 3 |
6 | Div2 | 34000 | Vendor 6 | Ref 1 | Invoice 3 |
7 | Div3 | 53000 | Vendor 7 | Ref 1 | Invoice 3 |
8 | Div4 | 12000 | Vendor 8 | Ref 1 | Invoice 3 |
9 | Div 1 | 11000 | Vendor 9 | Ref 1 | Invoice 3 |
10 | Div2 | 29000 | Vendor 10 | Ref 1 | Invoice 3 |
11 | Div3 | 56000 | Vendor 11 | Ref 1 | Invoice 3 |
12 | Div4 | 77000 | Vendor 12 | Ref 1 | Invoice 3 |
13 | Div 1 | 45000 | Vendor 34 | Ref 1 | Invoice 3 |
14 | Div2 | 33000 | Vendor 66 | Ref 1 | Invoice 3 |
15 | Div3 | 36000 | Vendor 76 | Ref 1 | Invoice 3 |
FP DATA
Risk | System | Division | Vendor No. | Vendor | Internal Ref. | Invoice No. |
High | Sys1 | Division 1 | 20000 | Vendor 1 | Ref 1 | Invoice 1 |
High | sys2 | Divison 2 | 30000 | Vendor 2 | Ref 1 | Invoice 2 |
High | Sys1 | Division 3 | 40000 | Vendor 3 | Ref 1 | Invoice 3 |
High | sys2 | Division 4 | 50000 | Vendor 4 | Ref 1 | Invoice 3 |
High | Sys1 | Division 5 | 55000 | Vendor 5 | Ref 1 | Invoice 3 |
High | sys2 | Division 5 | 34000 | Vendor 6 | Ref 1 | Invoice 3 |
High | Sys1 | Division 6 | 53000 | Vendor 6 | Ref 1 | Invoice 3 |
High | sys2 | Division 7 | 12000 | Vendor 8 | Ref 1 | Invoice 3 |
High | Sys1 | Division 7 | 11000 | Vendor 9 | Ref 1 | Invoice 3 |
High | sys2 | Division 8 | 29000 | Vendor 10 | Ref 1 | Invoice 3 |
High | Sys1 | Division 8 | 56000 | Vendor 11 | Ref 1 | Invoice 3 |
High | sys2 | Division 9 | 77000 | Vendor 12 | Ref 1 | Invoice 3 |
High | sys5 | Division 10 | 45000 | Vendor 12 | Ref 1 | Invoice 3 |
High | sys8 | Division 11 | 33000 | Vendor 14 | Ref 1 | Invoice 3 |
High | sys9 | Division 12 | 36000 | Vendor 88 | Ref 1 | Invoice 3
|
|
Solved! Go to Solution.
Thanks Caltang. It really helps.