Need help to join 2 SAP S/4HANA tables in a data extraction job with child table key value (16 digits leading zeros) and parent (10, 1 leading zero) are formatted slightly differently
Tried using Data type conversion CAST_TO_STRING, syntax seems OK, but get error when executing data job:
Error setting up extraction. Illegal join path configuration. Used resource neither child nor parent CAST_TO_STRING(DFKKZP] - DFKKZP] / DFKKPOH]. Celonis Support ID: 2b8cab5b-7442-41cc-9878-77ef645eeed1
Able to help?