I am retrieving values from a data table based on ‘Partner name’ values and experienced that the ‘Lookup Data Table’ activity cannot handle case sensitivity (like VLOOKUP in Excel). This is a problem for me because there are endless case type variations in which I may obtain the ‘Partner name’ value (e.g. I have ‘Dummy Name’ in the dt, but have to try matching with ‘dummy name’).
Is there anything I miss here? In case this is a lack of functionality of the activity what workaround do you suggest?