DSXchange

Thanks for your reply....

so, the main idea is that IsNull function return values are true, false, 1 o 0???

the other function you recommend will be in the "reject" constraint right?

Greetings,

Hi there! I assume that if you have a IsNull constraint in the transformer, is like if you're checking if your records exist or not. I mean... (I'll try to put it some graphic way...) ''''''''''''''''''''''''' Hash file '''''''''''''''''''''''''''''' | SQL --> Transformer --> Result file In this cas...

JUST AN IDEA

It could be with "doble pass" field function..... (based on the example)

I don't know why Fix() isn't doing what it's supposed to. You can use Field(InLink.TheNumber,".",1,1) : "." : Left(Field(InLink.TheNumber,".&qu ...[/quote] ok, let's give a shot.... now I have another question... my number is retrieved from a sql database (in the exampl...

kandyshandy wrote:Try directly mapping float(15) to Decimal data type in hash file with SCALE = 6.

I've already done this... it's mapped to decimal 7,6...

the transformer is sending the same.....

Another suggestion?

are the smile coming through in your data too ? :lol: Hi, Please consider the example as below for clarification:- input_string = A:B^~C:M^~E:F We want to get individual strings A:B, C:M, E:F Delimiter is "^~". Thanks, You can use the Field() function.... Something like Field(input_string...

Hi all there! I have a simple problem I get a number (float(15)) from a sql database and I have to insert this number in a hash file with truncated decimals (6 decimal). The number i got is: 3.1499999999999 and the number I want is 3.149999 when I use de FIX function something like fix(number,6,1) i...