Forum Discussion

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Solved

Add Leading Zeros

I have strings that are storing a two digit number (i.e. 00, 01, 02, etc) but I need to add another leading zero (i.e. 000, 001, 002). I don’t want to simply concatenate a 0 on the front in case I ha...
pranjbhatt's avatar
pranjbhatt
New Contributor III
12 months ago
Copy LinkReport

Hi, 

Following is the sample data. I need to have latest last_date values for each of the source (source_code) and each of the target table.  Note that date is in dd-MM-yyyy format.

 

INPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTconcentrix30-08-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
DIM_CLIENTenvizi27-08-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive
USERconcentrix29-08-202403-09-2024NowPositive
USER envizi27-08-202403-09-2024NowPositive

 

OUTPUT     
TARGET TABLESOURCE CODELAST DATE RUN DATELOAD STATUS TYPE
DIM_CLIENTconcentrix03-09-202403-09-2024NowPositive
DIM_CLIENTenvizi01-09-202403-09-2024NowPositive
USERenvizi28-08-202403-09-2024NowPositive
USERconcentrix02-09-202403-09-2024NowPositive