Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Creating a 'report' from data from a SQL db which shows a count of data collected on a weekly basis. The week starts on a Wednesday.

I have a sql table with a date field.

it shows Lab Code (MINA / Intertek), sample ID, Lab_report_date

I want to show this data as a table or export such as:

Capture 

The week is not calculated as a standard 'week', but from Wed - tuesday.

I've been playing around with DateTimeCalculator & Attribute Pivoter without much luck.

Is this even possible?

 

thanks

@tdunlevie​ can you use DateTimeConverter convert the date to a day of the week (%u) - you'll need the year in the date - and then use a lookup (AttributeValueMapper) to move the Monday based (1-7) to a Wednesday based (1-7) and go from there?

Reply


Community Stats

30,177
Posts
114,555
Replies
37,843
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.