Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avg sum in double Keys in load script

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

LOAD

Id,

avg(Sum) as Sum

FROM...

Group By Id;

View solution in original post

2 Replies
Anonymous
Not applicable
Author

LOAD

Id,

avg(Sum) as Sum

FROM...

Group By Id;

Anonymous
Not applicable
Author

Many thanks.