Avg sum in double Keys in load script

[Anonymous]

Dear colleagues, good day!

In load script i load table from excel with two fields:

Id,

Sum

What i need: if field Id has only one Sum - in this case to save the same value

                    if field Id has more than one Sum - calculate avg Sum.

There are model and source file in attachment.

Best regards, Andrey

Thanks.

[Anonymous · Accepted solution]

LOAD

Id,

avg(Sum) as Sum

FROM...

Group By Id;

[Anonymous]

Many thanks.