Vlook up multiple fields from a template

[Saravanan13]

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

[Raj · Accepted solution]

@Saravanan13 Join tool will be a good fit to achieve this result.

[gawa · Accepted solution]

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.