i am not a Pyspark developer, however correct me if my logic will work here ... Separate Dr and Cr ,then in Debit side multiply -1 , then union all three table/data set ..then select the district record system will add and minus those values .. Lemme know if you think this logic won't work.
Sagar, your code will fail if Total Credit is more than Total Debit. You have to reverse the summing and finally add when generating the result. Hope this has been captured and raised by someone else also 🙂
this was a very tough question but overall amazing
Bro tell me honesltly one answer if i see your video and i want to become a data engineer . Your content is next level.
@@praveenbhandari2516 thank you
i am not a Pyspark developer, however correct me if my logic will work here ... Separate Dr and Cr ,then in Debit side multiply -1 , then union all three table/data set ..then select the district record system will add and minus those values ..
Lemme know if you think this logic won't work.
Sagar, your code will fail if Total Credit is more than Total Debit. You have to reverse the summing and finally add when generating the result. Hope this has been captured and raised by someone else also 🙂