Data Manipulation

[Polite123]

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.:)

[messi007]

@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,

[danilang]

Hi @Polite123 

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

Dan