Hi,
I am new to Appian and using the "Import Excel to DB" tool in the Process Model. I want to read the data for example, starting 5th line and ignore the initial header or metadata in the excel. Where can i put in that configuration and how?
Discussion posts and replies are publicly visible
Skipping any rows is not supported. You will need to modify the Excel file before the import.
The other way out is firstly read the excel file by using readExcelDocument Function. in that function, you can provide start row as a row number and store the data into respective cdt and then you can use writeToDataStoreEntity to store the data into DB.
While this would work, it does not scale well. Larger Excel files will not work.
Correct, But in that case we can use import Excel to CDT and then we can use remove function to remove first 5 rows of that variable then we can use WriteToDataStoreEntity. It will be really appreciated if you can let me know any other way to achieve it.
And Stefan, 1 more query, i saw few folks are getting Portal Certification. Could you please let me know how to get it?
Sorry, this is off-topic and I am not a certification expert.