Unable to load excel data-range into Lookup table
Anyone, please help me to fix my automation issue, in my automation.
Data from excel cell range is not loaded in the lookup table, i'm successful till Tracker_Run(Export Data_Method), getting failed when it reached Lup_Tracker Lookup table (Replace Table_Method).
Note: Lookup table added in Global container and created the required columns in the string also defined the key.
Accepted Solution
Pegasystems Inc.
US
When you do an ExportData from Excel the column names of the data table need to exactly match what the lookup table column names are. I usually set CreateHeader to true which causes the columns to be named using the header row values and then I set the names of the columns in the lookup table accordingly.
Another thing that can cause a problem is that the key field in the data table created using ExportData may not be unique.
Check the logs to see what exception you are getting to determine what the real issue is.