Is there a way to add a date to workbench update

gatormain

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:

City	Count
New York City	2

 

The next  day, it comes through like this:

City	Count
New York City	4

 

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

City	Count
New York City	2
New York City	4

 

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:

City	Count	Date
New York City	2	11/1/2016
New York City	4	11/2/2016

nicolasfeddern

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.

 

 

nicolasfeddern

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.

 

 

gatormain

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

 

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

[Deleted User]

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

 

Thanks!
Dani