Hey folks,
following example for transformation:
Entity, SEntity
U1000000, US01
Z2000A01, CA03
K3430000, JP04
und dieser Zuordnungsformel:
Entity=IF(col(1,1:1)=U then SEntity;*col(1,1:1)=Z then *col(1,3:6); *STR(ERR))
is:
Entity, SEntity
US01, US01
A01, CA03
ERR, JP04
In my opinion, for the second row (starts with Z), this command wil be executed:
;*col(1,1:1)=Z then *col(1,3:6);
So, what is the result of *col(1,3:6) from Z2000A01?
I'm quite sure, it is not A01, but 00A0
Am I right or what didn't I understand? 😉
Rgds,
Christian