repeat a set of tools

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.

Workflow

Accepted answers

OllieClarke

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.

date transpose.yxmd

All comments

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

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

date transpose.yxmd

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280