DSXchange

Hi,

I am trying to generate a unique sequence number and appending that value to a string and the data type of that column is varchar.
For example the value would be 'ABC_123', but for my scenario the value is populating as 'abc_7.61778e+06' instead of 'abc_7617780'

Can you please help me to get the solution as i tried using stringToDecimal but didnt work.

An exact search here for "scientific notation" might prove helpful.

Hi craig,

I did a search on "scientific notation" but couldnt able to find a solution.

One solution i have in my mind is for example if i am getting the value as 7.61778e+06 then i can take the number before 'e' and multiply by 10 and the number after + which is '6' i.e 7.61778*10*06.

Can you please provide me a better solution if there is any other alternative solution.
And what would be the reason of getting a value as abc_7.61778e+06 of datatype as Varchar.
Is it because before the number there is a string , so it converts the value into abc_7.61778e+06 instead of 'abc_7617780'

Have you tried Concatenating the unique seq numeric value to varchar field?

yes my value will be 'abc_uniqueseqnumber

Try a different datatype for the number you are generating (would I be correct if I guess you have it defined as a float or double-float?)

Regards,

Hi,

Can you please provide me the solution as i need to use the datatype as Varchar . If i use the datatype as Integer it works but i nmeed to use the datatype as Varchar . And if i use Varchar i am not able to generate the number

So "use" it as an Integer and then convert it to a string before you concatenate it to your other varchar.

How do you currently generate the sequence number? A stage variable which you then concatenate to the other string before output? That stage variable should be an integer or big integer.

Regards,