Data Manipulation

Question

Hi Team,

I am stuck with a simple issue with huge data set

I have attached sheet here for reference with a very simple data set for example.

In reality data set is very huge and I am getting incorrect results

Sheet 1 is fist input file.

Sheet 2 is second input file.

Can you please help to solve the issue.

Thanks in advance.:)

Book2.xlsx

danilang · Answer

Hi @Polite123

Can you provide a bit more information on what your trying to achieve?  What should the output look like?

Dan

messi007 · Answer

@Polite123,

Please see below:

But doing a join on name could give wrong result cause I suppose names are not unique.

Attached the workflow,

Hope this helps,

Regards,

Join_20210407.yxmd