Excel generated from CSV is not importing data in table

Certified Lead Developer

Hi All, 

I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table. 

Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database. 

CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table. 

I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file.

Please advice what can be done resolve this issue. 

Thanks in advance for your help. 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data