Need to get user input for each row for a particular column

In this Screen shot (R1) you can see, Lease Commencement Date & Lease Expiry Date. Both are user input collected with help of interface tool. Its difference you can see in the Year Column in this case its 10. Since here the Total year is 10, with help of Generate Row tool, we have generated 10 rows starting from 1 to 10.

As shown in below figure (R2).

Now I have added a column as Increment, and I need to get user input for each row to the increment column.

This area we are stuck. Can anyone help to solve this.

output columns SHOULD BE AS SHOWN IN FIGURE (R3), Increment values are given through user input

r3.PNG

R1.PNG

R2.PNG

Interface Tools

Accepted answers

All comments

OTrieger

@anandakrishnan

One way to do it will be using excel file that contains the increment . You only need to have Year and increment. And then join the data based on years.

I think that this will be the easiest, nevertheless you can do it with chained workflow only you will need to create a macro that will generate the needed number of Text Box as you do not know how many years will be. It is possible but I think that it will be more complex than having additional file with the increment data.

anandakrishnan

@OTrieger But we need to take it as input from user while running the flow. Not as an excel input

OTrieger

@anandakrishnan
This was only a suggestion, if you would like to do it through User Interface, then another way will be to have a Text Box indicating to the user to add a comma between the different increment data. Connect that to a Text Box to a Text Input Tool and then to Text To Columns Tool splitting it to rows using the comma as the delimiter, add RecordID and then join it to the generated rows.

anandakrishnan

@OTrieger Can you suggest better way to this rather than putting comma separated values.

OTrieger

@anandakrishnan you can use any delimiter, does not have to be a comma, can be anything, hyphen, period, Dash, pipe, +, it does not matter what you will select, just a unique delimiter so later on you can split it to rows.

anandakrishnan

Hi All, Any other solution. To directly take the input against each row

OTrieger

@anandakrishnan
You can add it as a new idea for Alteryx.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703