Generate year

[ohruud]

Hi there, 

I have one question regarding generating rows.  I have some data that is missing fiscal year. I have attaced a photo of how the data is structured. And to identify which year the product belongs to is that from xx1-xx10, this range is lets say 2011.  When xx1 then comes next, this represent a new year, 2012.  That is, after each 10th record, a new year begins. This is probably easy to fix, but I a new to Alteryx and generally new to working with data, so hopefully someone can help me with this little quarrel I have 🙂

[fmvizcaino · Accepted solution]

Hi @ohruud ,

Attached is an example showing how to do it.

Let me know if you need further help.

Best,

Fernando Vizcaino

[ohruud]

Thank you so much @fmvizcaino, that helped 🙂

Best regards,

Ole Henrik

[ohruud]

Hi @fmvizcaino, 

I have one more question. The data in question was rather predictable as it is 10 instances for every year.  But if that were not the case, and the data were to irregular. such that for one year, one had xx11 and xx12 in addition, and then anoter, only xx9?  

Thanks in adavance 🙂

[fmvizcaino]

Hi @ohruud ,

Attached is a solution non-related to a specific number of rows, take a look! 🙂

Best,

Fernando Vizcaino