Hello,
I would like to do something very simple but the way I do it is quite sluggish and I feel I can do better.
Here is the example : I have a column A with 2 values. I want to create 18 columns identical to column A named Period 1 to 18.
I used counting loop start with rule engine using current iteration as input variable with rule engine stating true = column A.
Issue is that it creates the 18 columns but it also create identical lines. Therefore I use a group by to concatenate everything in the initial 2 lines. It works but still I am missing something on how it could be simpler…
Thanks for your help,
Bastien