Data Formatting Issue

[vidyasagar159]

Hi,

Can someone please help me the value alignment from the below screenshot. I want to start the value "457" from the left.

Options I tried in ScriptEditor:

TRIM

IF Condition

Replace

Thanks,

-Vidya

[giovanneb · Accepted solution]

Hi, try this

text(PLANTYPE) as PLANTYPE

Best reguards

[felipedl]

Hi,

Use the text() statement to transform your number into text.

Do something like:

Load

     text(PLANTYPE) as PLANTYPE

From [Whatever];

Felipe.