Generating Date and Populate Data within the range

[bdoni001]

Hello everyone.

I need your help.

I want to transform this table:

Into something like this:

Basically I want to populate the date that falls within the specified range and also the conversion rate that is applicable conversion rate.

Anyone knows how to do it in Alteryx?

Regards,
Bona

[JosephSerpis]

Hi @bdoni001 you can use the generate row tool to solve this challenge. You would need to do a conversion of your dates into a ISO format YYYY-MM-DD and then use a datetime add formula in order to achieve the results you specifed. However you could convert you dates back to a desired format after this process or do the conversion within the formula of the generate row tool.

[binuacs · Accepted solution]

@bdoni001 One way of doing this with the generate row tool

[grazitti_sapna]

@bdoni001 Here is my solution using generate rows tool.

[DataNath]

Here's how I tackled this - the conversion rates filldown as expected as well.

[bdoni001]

Thank you for your input!

[bdoni001]

Thank you for the input!

[bdoni001]

Thank you for the input! WIll definitely try this.

[bdoni001]

Thanks for the recommendation! Let me try this and see if it also works for me