Hi everyone,
Fairly new to ALteryx here and probably biting off more than I can chew.
But my issue is I have a file of 1m rows. Which contains weekly data for 1000 products accross 300 stores.
I need a price for every single week to make a calculation work, but the price column has a blank for the price where there are no sales.
How can I make a new field which basically says 'if this column has a price, use the price, if it is blank, use the price from the most recent week that hs a price, and if there is no price record in any week then give me a 0.
Thanks to anyone who can help!
@Annacsaa I think a multirow tool will be useful in this scenario. Please find a sample workflow attached
Thank you! so helpful!
Does it need to be sorted in a way that has the weeks of each store/sku combo next to each other?
What will happen if the row above also has no price? Would it go to the row before?
@Annacsaa can you please provide a sample test file with all the scenario included with expected result. The given workflow was a sample and it should re-design based on y our data.