Is there a way to add a date to workbench update

gatormain · November 2016

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 · November 2016

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 · November 2016

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

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

DaniBoy · November 2016

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

Thanks!
Dani

Is there a way to add a date to workbench update

Best Answer

Answers

Categories