• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a unique identifier

A

arjun.rdk

New Member
Everyweek I receive two sheets from SAP- Orderbook and shipped table. I am trying to merge these but the problem is there is no unique key that exists between the two tables. The closest unique identifier is sales order number and contract number. I have tried the following options;
1) used all lookups like xlookup and filter
2) Used sales order number as a unique key: But the problem is that in the orderbook some entries don't have sales order number.
3) I have tried concatenating the sales order number and contract number to create a unique identifier but the problem of duplicate entries arises.
MY purpose of creating a unique identifier is to merge these queries in power query so that I could get the billed data that exists only in the shipped table.
How do I find a Solution?
 
There's no solution without sample, it's not like we are mind readers ;)

But I fail to believe if the data is related, that SAP does not have relationship identifier in the data (perhaps under the hood). Your best bet is to get in touch with your org's SAP administrator/developer and request that column(s) to be added so data can be linked.
 
You must log in or register to reply here.
Back
Top