Need help in uploading a csv or a excel file in a custom adf page with click of button 'upload'
SummaryNeed help in uploading a csv or a excel file in a custom adf page with click of button 'upload'
We have a requirement wherein we need to upload 4-5 excel/csv files (one by one separately) using a ADF custom page in PaaS. For the 4 different file uploads, we will have 4 different upload buttons. Upon clicking on the upload button, file should be parsed and the data should go and sit in the respective columns in the dbcs staging tables.
Next, there would be a button in the adf PaaS page which says 'download', Upon clicking this button, the data present in the dbcs staging tables should be transformed(calculations performed on it) and it should be downloaded in excel or csv format onto the user's local downloads folder.