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: ABCABCCDFEFGABDCDEEFHABCCDKEFH Table2: ABC1ABD5CDF10CDE20CDK5EFG3EFH5 Table3: ABCSumABCCDFEFG13ABDCDEEFH30ABCCDKEFH11 Thanks in advance!

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

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!

Best Practices

Accepted answers

afv2688

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

sum_rows.yxmd

ThomasHagen

Hi!

Look at the attached workflow to achieve what you requested.

Match multiple rows.yxmd

All comments

afv2688

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

sum_rows.yxmd

ThomasHagen

Hi!

Look at the attached workflow to achieve what you requested.

Match multiple rows.yxmd

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?

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335