I have an excel file in which i need to filter a column and copy the filtered values to another excel. I have filter the column using tableview, But the problem is that i don't find any methods to directly import the data from excel to table view. So I used lookup table to export the data from excel and then i fed the data from lookup table to table view. Here i am facing an issue because the columns in excel are dynamic but i need to define the columns in the lookup table before exporting the data which i cant do as the columns are dynamic.
Is there any way to import the data from excel to lookup table, if the columns are dynamic ?
***Edited by Moderator: Pallavi to update platform capability tags***