Add leading zeros and replace

Toya2323 · ‎2019-07-25

I have

Load;

Text('ID') as ID,

Timestamp(`date`,'MM/DD/YYYY') as "Order date"

From _________________;

Output:

ID Order date

500001238 11/01/2018

0500001238 11/02/2018

000008734 11/01/2018

100007738 11/01/2018

0100007738 11/02/2018

0100007738_dd 11/02/2018

I needed it to look like this :

How do I replace 500001238 with 0500001238, 100007738 with 0100007738 keep the same order dates and not affect the two other rows?

venkat1 · ‎2019-07-26