Two amounts of data: run with each other

mathias_schnoor

Hi!

I want to create a macro. As Macro Inputs I have two amounts of data.

A simple examlpe:

the first quantity:

column A;column B

   1;5

   2;6

   3;7

   4;8

   5;9

the second quantity:

column C;column D

    6;7

    7;8

Now I will run with each other

and I will create in the macro value pairs and  handing over the pairs to the  Macro Output Tool: (as below)

column A;column B;column C; column D

1;5;6;7

2;6;6;7

3;7;6;7

4;8;6;7

5;9;6;7

1;5;7;8

2;6;7;8

3;7;7;8

4;8;7;8

5;9;7;8

It is possible in Alteryx? How?

Thanks

Mathias

MarqueeCrew

@mathias_schnoor,

if if you use the APPEND FIELDS tool, you'll get your desired results. Try it and see how it appends the data to every row. If you have more than 32,000 rows in your second file I will have to suggest an alternative. 

Cheers,

Mark