Excel Tools

Hi

Is there a way when usiing the import CSV to Database smart service and want to include a "row number"  in the target database in order to show which row of the csv the data was imported from?

The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs

Or

Is it better to just update the target database row number field after the import is completed ?

Regards

Hi

Is there a way when usiing the import CSV to Database smart service and want to include a "row number"  in the target database in order to show which row of the csv the data was imported from?

The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs

Or

Is it better to just update the target database row number field after the import is completed ?

Regards

you'd better set your "row number" columns in database auto_increment and then when it runs smart service it will automatically insert incremented values for each row in your table