Nulls giving incorrect results.

[kishorj1982]

Hi All,

PFA,

I have added nulls in table to handle drill down.But it is giving incorrect results. can you please suggest.

Thanks.

[kishorj1982]

Hi All,

Could you please suggest on this.

Thanks

[prma7799]

What is your expected output?

[Anil_Babu_Samineni]

Hello, Your explanation is not clear but you provided work file. If you explained where we are looking that would be Accuracy to reply

[kishorj1982]

I have added results before adding null and results after adding nulls in two separate tables can you please suggest what is the exact issue why I am getting different sum for collection amount against same set of data in two different tables.

thanks

[Anil_Babu_Samineni]

May be add this in your second tab?

[Anonymous · Accepted solution]

Hi,

In your script you suppress the duplication in the first table because you concatenate with a "load distinct" table

You should tri to add a counter in the first table like this :

lOAD

rowno() as ROW_ID,

CollectionAmount,

LOB,

COMPANYID,

FISCALYEAR,

Collection_Receipt_Date

FROM

Cash_Collection.qvd(qvd)

WHERE not Match(UPPER(TRIM(LOB)), 'IPWC','INTE','RETN','CC','MISC','UTAH','RENT','RETK','RETS','0008','')  and COMPANYID<>'10134'

and

FISCALYEAR >= '2017'

and

year(Collection_Receipt_Date)>='2017'  ;