DSXchange

Ah the buttons right there!! I couldn't see it before. Got it thanks

Yes it was a similar error with IsNotNull. Ah that makes sense. I'll get started on that and post results. Thanks :D

Sorry! Completely new to DSXchange, should learn to read

Thanks for the quick response! Oh whoops sorry I meant this is a parallel job. I don't know if that means IsNotNull should work in parallel or not? Regardless, I've tried the above as follows: If Not(IsNull(Field(Employee_Source.EMP_DATA,'|',47))) Then Field(Employee_Source.EMP_DATA,'|',47) Else &qu...

Hi everyone, I have a Sequential File stage connected to a Transformer stage and then onto an Oracle DB stage loaded onto the server. The information in the Sequential File stage is coming from a .csv and all information is in single rows, so I am using the Field function in the Transformer to split...