FlexFleet

Great tip! Thank you @mcoblentz

in Doing UPSERTS via Redshift Comment by FlexFleet April 2019

You can generate a timestamp in workbench by adding a transform. Add a new transform then select "Calculate Field Transform", then the calculation you need is "CURRENTEXECUTION". This places a UTC timestamp on your data set. If you what to shift the timezone then you add another transform and select "Shift Data Timezone…

in Create a Time Stamp Column, using data and time, in workbench for each time the report is ran. Comment by FlexFleet March 2019

Hi @jeremyhurren, For the search and replace function, do you know how find blank string and replace them with nulls?

in Workbench transform for NULL from SQL data Comment by FlexFleet March 2019

FlexFleet Member

Comments