Group By

[Anonymous]

Hi guys,

I have a small issue in using group by along with sum in load script.

Using the above code, I'm getting the expected result but with a small issue as shown below.

According to my code in the script, I need the maximum date count upto 31 but here I'm getting values more than that. I checked my source and found the problem too.

In the above screenshot, I have three values for that file date "10/04/2017" based on the file type but for date "10/03/2017" it's fine. I need to sum both values for the file type "RNI".

Please help me out to achieve this.

Attached the sample QVW below.

Thanks,

Siva.

[effinty2112]

Hi Siva,

Maybe add  DISTINCT to your left join's load statement.

Cheers

Andrew