DSXchange

Hello all. How can I set a default vale to a field when there is a lookup failure? I using a Lookup Stage to find matches between master and reference data. The goal I to append a field to the master data file with data from a field from the reference data were there matches. When there is no match ...

ray, the following seems to be working

Col_1[1, (Len(Field(Col_1, ".", 1)) + 1) +2]

It's parallel job. Sorry about that.

Hi all, I have a varchar field that is has decimal data. The data length is 19 the scale is 6. the data may or may not have leading zeros. I need to keep all the numeric data before the period with the zeros suppressed and only the first 2 numbers after the period. Is there a set of functions that c...

Thanks ray.

I had to add some columns to hold the keyed values from the lookup along with lookup results for testing. This worked out fine.

Thanks for replying chulett.

The first "can" is correct. I misspoke on the actual questions "Does anyone know how I can get this done in a server job?" Should have been "Does anyone know how I can get this done in a Parallel job?" Apologies

Hello all. I have a sequential file with several columns and two of the columns make up a key. I have a second sequential file that contains reference data. The second file has the same two key columns as the first file. Transformation on some columns in the first file is depended on the reference d...

Just wanted to thank balajisr. This code resolved many Fatal Error: Null value on the accessor interfacing to field "Field_Name".

Thanks chulett. Will do

This works great ray. Thank you.

Thanks for replying keshav0307.

Since UTF-8 can be multibytes, does it make sense to define the target field larger, e.g., Varchar length 100. Or is there some other solution I should consider?

Outstanding. This is much cleaner. Thanks folks.

This solution works great. Thanks so much

Hello all. I have a source database with a column which I have a constraint in the transformation stage. The target is a sequential file. This column has Null values. I have coded the constraint as follows: (IsNotNull(FldName_1)) or (Trim(FldName_2) = 'ERSA' And (FldName_3= '1') and (FldName_4<> 'Y'...

Thanks. Using the Director works fine.

I'm not sure how to tell if the job is Read Only.

The project is not Protected.