Import excel data into fields in custom table

[Anna_Servicenow]

I have the below requirement,

> We have a custom form (table) IPM task. I have created a UI action 'Import data'. Now when user attaches a excel with column 'case id' and 'resolved by'(column constant and number of rows keeps changing), the data in the excel should be exported to the field in the form like below automatically. How to achieve this?

[yuvarajkate]

It is an UI Action so it will work On Submit. There will be a button and when you click it it will execute the script. 

Please elaborate your use case if my explanation wasn't what you were looking for we can find a way to work around it.

[Anna_Servicenow]

I tried to use the above but I dont see it working. On clicking of import its going to the SI page

use case in simple words is , The data in the excel should be imported in the form section as rows( like shown in picture) without using transform map. 

[yuvarajkate]

Have you tried using that it does not redirect to the SI Page.

 action.setRedirectURL('current_page') //replace with the page of your choice.

[Anna_Servicenow]

Actually, it doesn't populate the value as well. Can you please provide the script in detail, also the attachment is done using the attachment icon on banner not via attachment variable when populating using ui action. Please provide script so that i can cross check with mine