How to match multiple rows to values in columns from another file?

[vmadyala]

Hi all, i am trying to match multiple rows in Table1 to Table2 values in columns from another file. Also in the end i would like to add a column of sum of those values for that row like in Table3.

Table1:

A	B	C
ABC	CDF	EFG
ABD	CDE	EFH
ABC	CDK	EFH

Table2:

ABC	1
ABD	5
CDF	10
CDE	20
CDK	5
EFG	3
EFH	5

Table3:

A	B	C	Sum
ABC	CDF	EFG	13
ABD	CDE	EFH	30
ABC	CDK	EFH	11

Thanks in advance!

[afv2688 · Accepted solution]

Hello @vmadyala ,

Here you have:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[ThomasHagen · Accepted solution]

Hi!

Look at the attached workflow to achieve what you requested.

[vmadyala]

Perfect!....thanks for your help.

[vmadyala]

I have another question. Now, i want to add a fixed number, let's say 10, across sum_field columns and i want that fixed number input to be dynamic for example i should be able to input a different number each time i run. Could you please help?

[afv2688]

Hello @vmadyala,

yes, you can indeed. You just need to add a constant to the workflow:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards