Skip to Content
0

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

May 10 at 09:15 AM

102

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ashu Yadav May 13 at 08:24 PM
0

Intresting one...

In this case i would find a table which stores the name of file being loaded to flatfile datasource on specific date then

Concatenate that filename with counter in end routine

So that once file is loaded to PSA and if i execute the DTP then endroutine should pick the file name from table

and create a key like filename1,filename2...filenameN..so on

Lets say if i add some 5 more records to excel file and modified some existing ones. and load same file after few moments then again again keys wills be ok

and if its daily activity...and records of todays file may appear on next day too ...then i have to go a step further to check the record before load.

Hope it May help

Share
10 |10000 characters needed characters left characters exceeded