topic Re: LOOP ADDING VALUE TO ID(validationID) in Integration, Extension & APIs

LOOP ADDING VALUE TO ID(validationID)

Ran — Sun, 01 Jan 2023 13:50:47 GMT

i have field "ID" with 5-9 digits

i need to that all ID to be 9 digits

and to add "0" to the 5-8 digits

example

123456789 -> 123456789

12345->000012345

1234567->001234567

after that i need to make more calcuation that check if ID is vaild/invaild

thanks!

Taoufiq_Zarra — Sun, 01 Jan 2023 21:42:27 GMT

@Ran you can use this expression :

repeat('0',9-len(ID))&ID as New_ID

example :

DATA: load *,repeat('0',9-len(ID))&ID as New_ID inline [ ID 123456789 12345 1234567 ];

output:

Ran — Sun, 01 Jan 2023 22:07:48 GMT

Thanks😄