Help with question

[gayathri27]

Can you advice on the best solution. I started with append and join but the join is not working for the line details and line categories dataset.

[geraldo]

@gayathri27 

to help you, it will be better to export the workflow and attach the yxdb file  to make it easier

[gayathri27]

I tried to follow along your workflow that you attached but I think the dataset is different. could you pls use the dataset I attached and explain to me.

[gayathri27]

I have attached the fields that I used for summarize and the final output .

As per the expected final output they have only 10 records and in my final output I have 13 records.

Any help is appreciated. Thanks !

[geraldo]

@gayathri27 

how are you!
If I understand what you want, your summary tool is configured wrong,
to have the desired output it must be with group by Transactions_ID concatened Vendors and Transfer Methods and if it has more fields than the print did not show also concatened