community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

How can I dynamically update the R12 M in alteryx workflow?

Highlighted

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!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Shubham085 

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.

Hi

 

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. 

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Shubham085 

The workflow you attached, refers to an excel file, that is not present in the attachments. Can you re attach the Excel?

Hi @aguisande

Apologies for the inconvenience. I am hereby attaching the excel files. 

Labels