Hi , 

I am trying to insert data from .XF file to MsSQL server via Optim. 
I mapped columns like below.
When I run this insert request , it is inserting but it has some rows with error.
So I checked and noticed Shuffle function needs some parameters. I added "Ignore" for null values but it is still has errors.



I got 2 questions ; 

1- Which other parameterd should I add  ?
2- Is there a way for writing  IF THEN ELSE statement ?
I need something like this -->>     IF <COLUMN_1> IS NULL THEN  NULL ELSE SUBSTR(<COLUMN_1> , 1,3 ) || '*******' END 

Thank you in advance , 

Best regards,

------------------------------
GUNES INAL
CEO | Chief Data Engineer
TECHBROS
+905309214847
------------------------------

#InfoSphereOptim
#Optim