Hi Alteryx Team,
May i ask about how to build the workflow based on 2 source data below related this scheme below :
Source Data 1
| Source | Transaction Amount | Description | Count |
| Bank Statement | -333000.00 | TRF IFT | 1 |
| Bank Statement | -11914.40 | PB Kreditur | 1 |
| Bank Statement | -9905.74 | PB ke Halim | 1 |
Source Data 2
| Source 2 | Transaction Amount | Count |
| Common File | -33000.00 | 1 |
| Common File | -11914.40 | 1 |
| Common File | -9905.74 | 1 |
| GL | -1000 | 1 |
Expected Data
(Here, i need to create the Source Data 1 as based data, and Source Data 2 as a reference to lookup into based data. If the count record for each amount between record in bank statement and common file+PV is the same, then the result RECONCILE. And for the NOT RECONCILE items will be if there's no match between count record bank statement and common file + PV.)
| Source | Transaction Amount | Description | Bank Statement_Count | Common File + GL_Count | Status |
| Bank Statement | -333000.00 | TRF IFT | 1 | 1 | RECONCILE |
| Bank Statement | -11914.40 | PB Kreditur | 1 | 1 | RECONCILE |
| Bank Statement | -9905.74 | PB ke Halim | 1 | 1 | RECONCILE |
| GL | -1000 | | - | 1 | NOT RECONCILE |
Hopefully you can help me to create this workflow since im newby in Alteryx.
Thank you.
Lydiea
