Hello Team,
I have list of more than 100 rules in a template attached sample. If I give input Columns B to column K as input I would need all the values from columns L to column R like shown below. can anyone assist on this.
Input -
S.NO | A | A-Amount | B | B-Amount | C | C-Amount | Joint Auth -All | Joint - Internal Amount | Joint - External Amount | No Movement |
1 | Y | 10000 | N | 0 | N | 0 | 0 | 0 | N |
Output -
Category | Sub-Category | Limit Type | Limit From | Limit To | Currency | Manner Of Signing |
Money Movement Exclusive | Money Movement ( Internal & External) | Fixed CCY Amount | - | 10,000.00 | US | Singly |
Money Movement Exclusive | Internal Moneymovement (within client Relationship) | Unlimited | - | - | - | Singly |
Solved! Go to Solution.
@Saravanan13 Join tool will be a good fit to achieve this result.
hi @Saravanan13
As @Raj said, JOIN tool should be used. Please refer to the attached WF how to configure JOIN tool in your case.
Please note that if the field type of key field contains double and/or float, Alteryx would throw a warning "Joins on Double or Float are not recommended due to rounding error". In your case, column "A-Amount", "B-Amount".. can be double. If this is the case, please be careful. Or, these columns always have integer value, no need of worry.