Excel to SQL [PostgreSQL]

I am busy converting an Excel report into SQL. SAMPLE_Mapping_.xlsx
I am getting the Fact data from a SAP source. I assigned primary keys to identify each of these rows as unique in the SQL table.
I filter on "Account" column in the SQL table and Source.Account in the excel sheet for "30101020".
source.png

And in SQL

SOurce2.png

SOurce3.png.

When i filter per unique code, i get multiples which are duplicates and it should not be.
How do i ensure that i dont get any duplicates
source4.png
, but also that my figures(money) are correct?

When i use "ORDER BY "Source data.Company Code"", i get unique primary keys, but the "Amount in Company Code Currency" will include different figures.

Please Login or Register  to view this content.

What database are you using?

This is not an Excel question. Not really a question about any Microsoft product. I'll move the question.