I wish to transform a certain range of columns at once:
The table has week 1 till week 53. I want all of these to be DateDataCell and format it with "E" (to show Mo or Tue etc).
I also wish that they are only shown if the week number is between a slider.end and slider.start.
I managed to do this manually by changing each column, and adding a custom 'show column'.
However I wish this to be done with code, for example in the Query transformer. Is this possible?
Thanks for thinking with me,