Skip to Content
0
Former Member
May 10, 2018 at 09:15 AM

Identify Key Fields for (advanced) DataStore Object (aDSO) in a big excel data

1748 Views

Dear all,

I have a huge excel data (with thousands of rows and more than 100 columns) which I would like to upload on my (advanced) DSO.

I donot have a single unique ID in my data and therefore have to look for characteristic combinations as KEY FIELD for my DSO. Adding an additional column and creating an artificial key field is not an option that I would like to use. Pivot table might be another option but I could not be sure as to how I can check unique row-records in my table using this tool.

Thank you very much for your time and help!

Regards.