repeat a set of tools

[RSLippe]

Hallo everyone,

I am a very beginner for Alteryx. I have a data set which contains more than 100 project name (100 fields) and each project also includes it information i.e. project_start and project_end, which means that there will be in total 300 fields.

Now I would like to transform this data form into a vertical format (as described below) given that one household can also participate in more than 1 project:

householdid   project_name  project_start   project_end

1                    xxx                   2 Jan 2016

1                    yyy

2                    xxx

Currently, I just selected a project and its information step-by-step and at the end I would use the "union" tool to append all the data files from each project. 

Since I have to do the process for 100 times, is there a way to repeat it automatically.

Many thanks in advance.

[afv2688]

Hello @RSLippe ,

If you could share some dummy data showing how the data input is I may be able to show you a solution.

Regards

[OllieClarke · Accepted solution]

Hi @RSLippe this isn't technically answering your question, but the following workflow I think will show you how you can restructure your data:

You can select tools in Alteryx and then copy and paste them if you wanted to do that, but normally if you're repeating sections of your workflow, then it's a sign that you might want to restructure your data. Also check out macros which allow you to condense a workflow into a single tool which you can then use elsewhere.

[echuong1]

If the input files have the same schema, you can actually just use a wildcard (*) in the file name within the input data tool. This will run through all of the inputs with the specified format/naming convention and union all of the results together automatically. 

[RSLippe]

thanks a lot. It works well

[OllieClarke]

Good to hear @RSLippe. Would you mind marking the answer(s) that helped you as solutions, so people in the future can more easily find them?

Cheers,

Ollie