DSXchange

I had set First Line is Column Names =True'...Even though I am getting.

Hi All, I am also having the same problem as I am using sequential file as lookup and it has one integer field which is nullable. I got the warning like Field "<field_name>" has import error and no default value; data:at offset<field_name>: 17 <field_name>: Import warning at record 0. I ha...

Thanks,its working fine as I have used other functions.

Thanks for your response. I have tried in ouput column derivation : If NOT(ISNULL(input.field)) Then Num(input.field Else NullToZero(input.field). I got the same warning and again I tried with If NOT(ISNULL(input.field)) Then StringTodecimal(input.field,"round_inf") Else NullToZero(input.f...

Hi Friends, I have one field which is Varchar datatype in source and I need to check if it is not null and if it not an integer I have to set it to null else populate the same and write error msg.But my output column is an Integer and I have used If IsNotNull(input.field) and Num(input.field) in sta...

Thanks a lot for your response.Now the requirement is changed.

Regards
Anju

Yes.Plz explain me how you have done it.

Thanks

I am using parallel jobs.I have used SringToTimestamp alone it works.But I need mm/dd/yyyy with am or pm based hrs.
Any one can suggest.

Thanks
Anju.

Can I use Iconv and Oconv functions.If it is so how to use those functions.

Thanks
Anju

Can I use Iconv and Oconv functions.If it is so how to use those functions.

Thanks
Anju

Can I use Iconv and Oconv functions.If it is so how to use those functions.

Thanks
Anju

Yes The default format is yyyy-mm-dd hh:nn:ss.So can't I change the format with am or pm to timestamp.I tried StringToTimestamp and all.But I can not.Suggest me on this.

Thanks

Hi Friends,

I have timestamp filed with varchar datatype and I need to convert it to timestamp with different format mm/dd/yyyy and hours should be 12 hrs basis am or pm.
Can any one suggest.
Thanks in advance.

Regards
Anju

Hi Friends,

I have a job in which if the lookup condition found ,field name sould map to the output else set Null to the output.Can we specify in lookup like the contion not found? to set it null.
Plz help me out on this.

Regards
Vilasini

Thanks for your response and we will try to use containers.