Hi all,
I am not the best at scripting in Python nor in SQL, so it would be great if somebody could help me with optimizing a script we have to map our ICPs
Situation
Our source system is coming with 6 digit ICP partner, in HFM we only have the ICP as 4. An example is the following
Source: 151060
HFM: 1060
The most cases the ICP always matches the last 4 digits of the source system. there can sometimes be cases where it should not map to the same last 4 digits, so the script could have an exception list, sort of like
If entity x go to y, else use the last 4 digits.
Below is a snipplet of the current code which is just too huge we had to split it into two mapping rows. You can see that it's just taking the last 4 digits in most cases, except for example below 151040.
======================================================================
arrAccnt = ('11670000')
ICP = fdmRow.getString("ICP")
if fdmRow.getString("ACCOUNTX") in arrAccnt:
if '_151000_' in ICP:
fdmResult = '1000'
elif '_151002_' in ICP:
fdmResult = '1002'
elif '_151004_' in ICP:
fdmResult = '1004'
elif '_151005_' in ICP:
fdmResult = '1005'
elif '_151020_' in ICP:
fdmResult = '1020'
elif '_151030_' in ICP:
fdmResult = '1030'
elif '_151040_' in ICP:
fdmResult = '7197'
elif '_151060_' in ICP:
fdmResult = '1060'
======================================================================
Thanks so much for the help.
Regards
Roman