Hi community :)
I need a table where certain rows have a color based on certain rules. Only row 1 and 3 need colors (advances and loans). How do I create the formula if the days of the month will change each week?
Thank you in advance!!
Solved! Go to Solution.
Hi @Kristie_Pires ,
Not sure if you're intending to keep this in Alteryx and output via Reporting tool palette, or if you're planning to write the data out to e.g. Excel?
In the past, if I've had complex formatting requirements I've found that Alteryx pairs well with Excel VBA. You can export your unformatted data to a .xlsm format template file with pre-written VBA set to trigger when the file is opened - you can also set it to save itself as .xlsx after it is done. When your output is produced, you would simply have to open the file and it will handle the formatting for you.
Alternatively, tools like Power BI/Tableau would allow you to visualise this the way you want to.
Assuming you do want to use the Reporting palette however, I've had a look and believe the changing date columns may be an issue. Is it a problem if you convert these to day of week format? You could use the Report Text tool to call out that the table relates to week commencing "4-Nov" so that you don't lose that detail.
Having a quick play with the Table tool, it seems that to get the behaviour you're looking for it is easier to use the Column Rule (hence setting consistent column names as suggested above). I attach an example formatting the "Monday" and "Tuesday" columns.
