Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Siva,
Maybe add DISTINCT to your left join's load statement.
Cheers
Andrew