Adding two Zeros at the end of the text

[nevilledhamsiri]

Hi,

I have BR_Code such as RA but I need to make it as RA00, The  changes that were mage in the script as follows but I wont get the expected output. Cn some one help me on ths.

LOAD Text( BR_CODE) AS BR_CODE,

     AMOUNT

FROM

D:\TET.xlsx

(ooxml, embedded labels, table is Sheet1,filters(Replace(2,top,StrCnd(null));

Neville

[vvira1316 · Accepted solution]

try

LOAD Text( BR_CODE) & '00' as  AS BR_CODE,

     AMOUNT

FROM

D:\TET.xlsx

(ooxml, embedded labels, table is Sheet1,filters(Replace(2,top,StrCnd(null));

[nevilledhamsiri]

Thank Vijay,

That is what I looked forward to. I tried applying  the same formula adding two zeros in front as well then the answer comes as 00RA.

Neville