I am just curious if there is a way to add 2 rows to the top of my data output excel file. I have looked at the render and header tools but I don't think those are what I need for this. I have this report fully automated with Alteryx and was just wondering if there could be a way to eliminate the final manual step. In the screenshot of my excel book attached I am curious if there is a way to have Alteryx create the first 2 rows, which is my title of the data set and range of the sales data. Currently I run my workflow then insert these 2 rows manually after Alteryx creates them. Any help would be greatly appreciated. Please and thank you.
Hello @ryanheite
One way to do it is to use Blob tool. By creating a blank template of the excel file with all the colours and font setting, you could call to that template, write it out and then fill in the data to specific ranges. In that manager you could adjust the first 2 lines with the most current data and then write out the rest of the data bellow.