This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Looks aren't everything... But the latest Community refresh looks darn good!
Every month the R12M changes. How can I automate the formula in alteryx workflow the dynamically take R12M columns from the ecxel file and generates the desired output?
I have attached a sample file for reference!
I'll be making a theoretical approach, since I don't have the data.
First: calculate the range of periods you'll need (Generate Rows can help you with this)
Then transpose your data file
Join the data file to the required periods (on date)
That'll give you the periods you need
Can you attach the data or a sample of it? That'll make the workflow usable.
Thank you for reply. I tried your approch but could not implement it. I am hereby attaching a sample file for R12 M. Kindly implement your approch.
The workflow you attached, refers to an excel file, that is not present in the attachments. Can you re attach the Excel?
Apologies for the inconvenience. I am hereby attaching the excel files.