Hi,
We have an Excel sheet which contains total 110 column fields in it and has total 18 rows data present for each column. Here, we need to Import this Excel data to three different tables in DB. The column fields which are present in the Excel sheet same columns are in separate three tables. When user uploads the Excel sheet, this "Import Excel to DB" smart service should be able to import data in three different tables.
Please help with the configurations for the Import Excel to DB smart service or we have any other way to import excel to three different DB at an single process click ?
Appreciate you support !
Thanks
Discussion posts and replies are publicly visible
I'm looking at the Import Excel to DB smart service node and it looks like it might not be flexible enough for you with respect to the columns you can use from the Excel at any one time.
If all else fails, I think you should be able to utilize the "readExcelSheet" function, where you could read the entire contents of the Excel sheet into one data dictionary, and then use further logic within an Expression Rule to separate the data into different outputs (and then into different CDT arrays) which you can then go ahead and write to your database tables using the normal Write to Data Store node.
Hi Mike Schmitt,
Thanks for the solution..
Whether this "readExcelSheet" function is configured in Import Excel to DB smart service ? Please could you give some examples so that i may try to implement in project.
Thank you..
I'm not exactly sure what you're asking. The readExcelSheet function simply reads the values out of the Excel file and gives you Appian dictionary data, which you can then do whatever you want with - like passing that data back into a process and then writing it to a DB table.
Thanks Mike Schmitt
Hi Mike,
I am getting error as shown in snap and I am using PostgreSQL database.
Thanks,
Kiran