Number and string

[spividori]

Hi.

I perform a query showing the client code from 2 different tables and throws me the following result:

I need that the second value to be as the first. How I can solve it?

Regards.

[#2]

If you are only looking to change the way it is displayed, go to Chart Properties > Presentation > Alignment and set both text and numbers to the right.

[Anonymous]

num(evaluate(ClaveCrm))

[Clever_Anjos]

Use num#() transformation while load your data

Example:

LOAD

     num#(trim(ClaveCrm)) as ClaveCrm;

SQL SELECT

     ClaveCrm

from your table

[maxgro]

text(ClaveCrm)  to left align

or

num(ClaveCrm)

[spividori · Accepted solution]

HI.

Thanks for replying. I solved it by changing the settings of a ThousandSep and DecimalSep and it worked..

SET ThousandSep=','; SET DecimalSep='.';