Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Saving Output as per Latest Timestamp

areeba
8 - Asteroid

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?

4 REPLIES 4
Morgan_Thomas
8 - Asteroid

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
17 - Castor
17 - Castor

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

 

DavidP_0-1618496682041.png

 

areeba
8 - Asteroid

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
8 - Asteroid

hi @atcodedog05 

 

Can you help in above problem ?

 

Thanks 

Areeba

Labels