Generating Date and Populate Data within the range

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

Workflow

Tips and Tricks

Transformation

Preparation

Accepted answers

binu_acs

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

Conversion_0912.yxmd

All comments

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.