SourceCode modification on System Fields

  • 1 March 2017
  • 1 reply

Did anyone tried to rename or modify the source code on system fields from being 'customdata' based on the filename or business unit you are unloading a text or excel file?

I would really love this as this source code is one of my primary keys and it's uniform irrespective of the business unit I unload the data becoz of excel docs being used.


Best answer by Thomas Lind 17 January 2023, 14:15

View original

1 reply

Userlevel 5
Badge +5

Hi Satish

Sorry for the delay.

If you want a field containing the datasource name for a textfile based data source, you can do so with a CData CSV provider.

Aggregating the files will add the URI name as a field which can be used as a primary key.

A similar thing is done automatically for Excel as it will have a row option which will be a unique value for the row. This can be used as a primary key as well to make it a unique row.

Thomas Lind