3535860 - Error is referring to data which is in another column during Process Intelligence extraction

During Process Intelligence extraction, getting following error:
Error obtaining value 'xyz' for column 'abc'. Failed to convert to datatype: '123'. The original datatype of the column is: '123'

However, 'xyz' actually does not exists in column 'abc'.

Related user guide: https://help.sap.com/docs/signavio-process-intelligence/user-guide/sap-erp-connector-related-errors?q=sap+rfc

Reason error message shows data which doesn't exist in the column is explained per below and followings need to be considered:

1. Default delimiter is "~", however, because your data contains "~", it's moving part of the value (the part after the ~) to the next column and thus error message resulting in showing value which exists in the next column.
2. ReadTableDelimiter= needs to be applied set to a delimiter which is not used in your data in your arguments configuration, for example, you can use ReadTableDelimiter=| (pipe symbol) or  ReadTableDelimiter=§ (section symbol) or any other symbol that is not contained in data values themselves. 

Advanced
Non printable characters like the following can also be considered

• Delete -  https://www.ascii-code.com/127
• Escape -  https://www.ascii-code.com/27
• Data Link Escape -  https://www.ascii-code.com/16

To get these characters into the clipboard:

• Windows: powershell -Command "[char]16 | Set-Clipboard"  (use the ascii character number - here we use 16)
• Mac: printf "\x10" | pbcopy (use the hex code - here x10)

You can test that the character is in the clipboard by pasting into a text document in Notepad++ and ensure View > Show symbol > Show all characters is enabled.

soe, ReadTableDelimiter, Process, Intelligence, RFC, Extra, Connection Arguments , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem

SAP Signavio Process Intelligence all versions