Summarise Data

Hi All,

I have a workflow which produces an excel file with invoice data from our Financial system, there are sometimes several lines per invoice. I want to summarise the data into 1 line based on 3 columns, company ID, document type and document number, i.e. if the data in these 3 columns are duplicated summarise into 1 line. I can't get the summarise tool to work as it only outputs the fields I summarise on. Help on this would be appreciated.

Transformation

Accepted answers

Raj

@SandyCovey
find the workflow attached
hope this helps

if you are looking for something else please add sample input and expected output
mark done if solved.

3256.yxmd

All comments

binu_acs

@SandyCovey Can you provide sample data and expected output for the better understanding or your use-case?

aatalai

@SandyCovey take a look at the unique tool that might help. Let me know how you get on

Raj

@SandyCovey
find the workflow attached
hope this helps

if you are looking for something else please add sample input and expected output
mark done if solved.

3256.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703