Is there a way to add a date to workbench update

Is there a way to add a schema column for date for when the data was sent over?

 

From what I've seen, this is not possible, but there may be an optinon I missed or a workaround with SQL

 

For example, the Google Analytics connector adds a _BATCH_LAST_RUN_ column, which is similar to what I want but for workbench jobs. This would indicate when the data came through, which would be very beneficial for datasets without dates. I could use this date for trending analysis. 

 

Say I have a dataset come through daily like this:

CityCount
New York City2

 

The next  day, it comes through like this:

CityCount
New York City4

 

If I append the data, it will be like this:

CityCount
New York City2
New York City4

 

There is no way to differentiate the days each row came through.

 

My ideal state would be every update, it would be something like this:

CityCountDate
New York City211/1/2016
New York City411/2/2016

Best Answer

  • You can use the Workbench transformations to add a column that inserts the current date. This should give you the date column you're looking to add.

     

     WB_Calcs_Screenshot.png

Answers

  • Thank you @nicolasfeddern! I found it after poking around more.

     

    Didn't know it was under the 'Calculated Field Transform' type.

  • @gatormain if this solved your question, then please mark Nic's answer as the solution.

     

    Thanks!
    Dani

    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
This discussion has been closed.