Workflow Help

[fabrizio]

Hello, 

Help needed on reconciling BB to AA based on quantity and character. The reconciliation will be on a 1/1, 1/multiple, multiple/multiple basis. The unique key identifying both sides is the ID. The output file should only have matching values. Thank you!

[fabrizio]

Hi Ponraj,

thanks for sharing the updated workflow. However, as I mentioned to you on the last post, it duplicates values when returning matching output file. Take for example the MM code, the ouput file is supposed to get only 3 matching MM code as follows:

8/15/2018	MM	WAWR1	5555
8/15/2018	MM	EQFWQT	5566
8/15/2018	MM	EWWR	5505

However, what the workflow you suggested does is to return MM 9 times because it reads all the MM with each source. In this case since there are 3 sources, it matched the MM code with each of the source reason why it returned 9 values wheres it is supposed to match each MM with its unique source thus returning only 3 values. Does that make sense?  Remember that each orderID is unique and should therefore only appears once with its matching source reference

[ponraj]

Uploading the updated workflow.  have concatenated the values in case there are more than one value for source and Order ID column. Hope this is helpful. 

WorkflowResults

[fabrizio]

Results are showing as expected but not in the desired output format. Would have wanted matching codes to have their source and orderid show in separate columns and not separated by commas in one column as you did. Is there a way I can do it? Thanks

[ponraj]

can you share desired output(in a table how you would like to see the results) you are looking for the sample data you shared? 

[fabrizio]

Hi Ponraj,

please have a look at what the output should look like for code MM for example:

8/15/2018	MM	WAWR1	5555
8/15/2018	MM	EQFWQT	5566
8/15/2018	MM	EWWR	5505

Thats the desired output am expecting for each matching code and quantities. As i said earlier the ouput you came up with is good but needs to be formatted as shown above with MM.

[ponraj]

Hi @fabrizio, Attaching updated workflow. 

WorkflowResults

[fabrizio]

Great Ponraj! Is there a way I can fill in the blank for the rest of the codes? See example below, your ouput shows as follows:

Activity	Code	OrderID	Source
8/15/2018	EE	JHJ32	230
8/15/2018	EE	HUGF23	235
8/15/2018	EE	LPJI0TE89
8/15/2018	EE	HHFJK00
8/15/2018	EE	HUIAI52

Is it possible to get one that shows as follows?

Activity	Code	OrderID	Source
8/15/2018	EE	JHJ32	230
8/15/2018	EE	HUGF23	235
8/15/2018	EE	LPJI0TE89	235
8/15/2018	EE	HHFJK00	235
8/15/2018	EE	HUIAI52	235

[ponraj]

Here you go!

WorkflowResults