I have mapped the Data and trying out the Execute Data Loading tool, where I am facing this issue, even after I have specified just the Lookup table and not the expression. Can someone please help me?
Could you try changing the name of the description column to something else? I wonder if it is removing the (description) from the name of the field and it thinks there are two fields of the same name.
Appears that a pandas change may have caused this. If your pandas version is 1.3+ that may be the culprit. A possible workaround for now is to force the Expression column to be read in as a string field during processing. Ie. map another target field using something other than an integer. You might also try changing "20" to "int(20)". A bit silly but that should work.
I think we will pin the pandas version for these older versions of Data Loading Tools to avoid these issues going forward.