Saving Output as per Latest Timestamp

[areeba]

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?

[Morgan_Thomas]

Have you thought about using a formula tool to replace the existing time stamps with DateTimeNow() ? That will update every time the workflow is ran. Attached an example.

Thanks!

[DavidP]

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

[areeba]

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

[areeba]

hi @atcodedog05 

Can you help in above problem ?

Thanks 

Areeba