Transformer V7.0, date wizard and number of week (1-52)

[SPI33]

Hello everybody,
In the module transformer V7.0, I try to define a dimension date from a date field (DD/MM/YYYY) resulting from my iqd file. I use the function "date wizard". The category "week" brings back the first day of the week but I will wish to have the number of week (1-52). How to make?
Thank you for your help.

 

[GJParker]

One way is to add the week number into the IQD and use this as the label for the week category in your model.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[ukflix]

If week number is not available to add to your source data, another way is to create a lookup table in Excel with 2 columns. One with the week start date and another with week number. The week start date column must be named as your date column and then the description can be added as label as GJParker said above.