Skip to Content
avatar image
Former Member

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

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!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 13, 2018 at 08:24 PM

    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, 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

    Add comment
    10|10000 characters needed characters exceeded