Attached sample flow .
somehow I could not pad 0s in string like 1:Key so I used string manipulation to solve this.
Also used separate dynamic select for - ve values.
Yes! No macro required!
You will transpose the data and keep the "static" data as keys. Then you'll use a formula that groups by ID (I checked the wrong box in my configuration in the picture, but fixed it in the post). I created a formula near yours and called it new_value. Then I used the crosstab tool to horizontally view the data.
There is a version 10.x and a version 11 sample for you to work from.
I haven't found a solution to automate changing the existing links. However, I found something that prevents me from getting into this situation in the future in the first place:
Adding hyperlinks using the appropriate icon from the GUI toolbar results in an absolute path for this link (even for content that is already uploadad as "media" to the Alteryx server).
In order to get around that, one has to click on "source code" in order to edit the links directly.
Doing so, one should define the URL as relative to the root folder of the Gallery, e.g., "/api/media/ ..." The first forward slash is important in that case!
I am in Regex mode today so I threw in a regex, you could also use string functions (LEFT) to pull out the week.
Once you have that the Crosstab flips the data for you.
I included some simple data.
I have discovered the problem
The object name is too long in NFD/NFC when connected to Teradata Error occurs when you use SQL comments above the SELECT statement within the Connect In-DB customer query box. Once the comments are removed the problem is resolved. Pity I cant use comments though.
In the Alteryx systems settings (This should be a desktop icon) you will need to go to the 'Run As' Settings and enter in your credentials so the scheduler runs as you rather than the service account.