Hi,
I have one requirement where i am having 3-4 columns and one column is time stamp. The column Timestamp prints today date ,time, hours and seconds.
For example :
A B c Time_stamp
One 1 Hello 2021-04-15 15:31:41
Two 2 Hi 2021-04-15 15:31:41
Three 3 hoi 2021-04-15 15:31:41
After some time my column values changes and also the time
For example:
A B c Time_stamp
One 1 Hello 2021-04-15 15:36:41
Two 4 Hi 2021-04-15 15:36:41
Three 6 hoi 2021-04-15 15:36:41
I want to output as per the most current/latest time stamp with rest of the values in my final output.
Final output should be this:
A B c Time_stamp
One 1 Hello 2021-04-15 15:36:41
Two 4 Hi 2021-04-15 15:36:41
Three 6 hoi 2021-04-15 15:36:41
So every time it should print the latest values as per timestamp and override the previous values.
How should I achieve that?
Hi @areeba
You can find the latest timestamp with a Summarize tool and use that to join with your data and just keep the data that matches this timestamp
Hi @DavidP ,
Let me rephrase it ...I have two files .
File 1
A B c Time_stamp
One 1 Hello 2021-04-15 15:31:41
Two 2 Hi 2021-04-15 15:31:41
Three 3 hoi 2021-04-15 15:31:41
File 2
A B c Time_stamp
One 1 Hello 2021-04-15 15:36:41
Two 4 Hi 2021-04-15 15:36:41
Three 6 hoi 2021-04-15 15:36:41
and these two are getting save in one output sheet as Consolidation file, which looks like this :
A B c Time_stamp
One 1 Hello 2021-04-15 15:31:41
Two 2 Hi 2021-04-15 15:31:41
Three 3 hoi 2021-04-15 15:31:41
One 1 Hello 2021-04-15 15:36:41
Two 4 Hi 2021-04-15 15:36:41
Three 6 hoi 2021-04-15 15:36:41
Now, what i want is ...when i run my workflow again for File 1 , the records in Consolidation file replaces with latest timestamp.so it should display like this:
A B c Time_stamp
One 1 Hello 2021-04-16 15:31:41
Two 2 Hi 2021-04-16 15:31:41
Three 3 hoi 2021-04-16 15:31:41
One 1 Hello 2021-04-15 15:36:41
Two 4 Hi 2021-04-15 15:36:41
Three 6 hoi 2021-04-15 15:36:41
The idea is to replace the records with latest timestamp in Consolidation file.
Can you help?
Regards
Areeba