Close popover
Madhan Sevugamoorthy (MadhanS5)
Ford Motor Company

Ford Motor Company
MadhanS5 Member since 2019 1 post
Ford Motor Company
Posted: May 9, 2019
Last activity: May 9, 2019

Export data from Excel to Lookup Table where the columns in the Excel are dynamic

Hi All,

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***

Data Integration Robotic Process Automation
Moderation Team has archived post