Hello,
I am new to Alteryx and I am having a tough time finding a solution to formatting my "Start Range" & "End Range" data to become column headers.
Then I need to populate an applicable Bill Amount that falls in between the range, per another columns Bill date. Below is the Original Data:
and I need to turn it into this:
I also am up for another suggestion of formatting, as long as the various Rental Bill date and It's Applicable Amount can can fall underneath the beginning bill week cycle.
any suggestions?
Thank you!
Solved! Go to Solution.
Hi @JohnDella
@PhilipMannering has a great solution for your sample data set, but using a RecordID tool to generate the Cross-tab column headers doesn't allow you to have more than 1 WAV # without duplicating the date columns for each wave. The attached WF changes the RecordID to a Multi-row to handle this situation.
Since you also mentioned that you were open to other formatting options, I added a second wf that generates week based column headers.
This has consistent column headers even if the bill date varies between WAV #s as show below
Dan
Thank you. This was very helpful
Thank you. This was perfect, as I do have more WAVs, and they duplicate too. This workflow solved my problems of formatting and bringing in the applicable bill amount.