Hello All,
My requirement is client is sending an csv file to Appian which we need to insert in Appian table.
I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer.
Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that.
But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself.
Thanks in advance
Regards
Sahil Batra
Discussion posts and replies are publicly visible
Hi, I don't think we have any function or smart service for that.
1. we have one parameter which we pass for a header which actually means the column names and we have an option for that in Appian.
2. We can use readexcelsheetpaging function which is part of plugin we can avoid the indexes where we have headers and footers.
Hello
Thanks for your reply.
1.The Input Parameter you are talking about is for the column Name. In File I am getting column name that I have to read from file only.
2. readexcelsheetpaging :- This function will work for excel not CSV. I have to read the CSV File
I think the only way is to change the CSV format