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
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.
Regards
Thomas Lind
+5Hi 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.
Regards
Thomas Lind
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
