appending values to id

[vinod2086]

Hi all

I have ID column in that column when Id beginnings with 9 then i need to append 0 , remaining IDs i dont want to change

ID
3456 9123 9876 3456 8765 345 98776

i have applied condition if ( not IsNull( ID),'0'&ID) it appending all values

[awhitfield]

HI Vinod,

that may be easier to do in the load script, are you trying to add to ) to the start or end of the ID?

Andy

[anbu1984]

T1:
Load If(ID like '9*', '0'&ID,ID) As ID Inline [
ID
3456
9123
9876
3456
8765
345
98776
];

[jsanchezh]

Try with the left function:

     if(left(ID,1)='9', '0'&ID, ID)     as ID

[jagan]

HI,

Try like this

LOAD

*,

If(Left(ID,1)='9', '0' & ID, ID)  as New_ID

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[amit_saini]

Vinod,

Try this in calculated expression:

=if(Left(PLANT, 1) = '9', '0'&PLANT, PLANT)

Thanks,

AS

[vinod2086 · Accepted solution]

Hi

instead of using like i have used match function its working fine

if(WildMatch(ID,'9*'),'0'&ID,ID)

[#8]

this one works

if(WildMatch(ID,'9*'),'0'&ID,ID)

[jagan]

Hi,

You can also achieve the same by using Left() like below

If(Left(ID,1)='9', '0' & ID, ID)  as New_ID

Regards,

Jagan.