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 · Accepted solution]

@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

[mathias_schnoor]

Hi Mark,

as is often the case, the solution to the mystery is simpler than one might think.

Thanks a lot.

What happens when If I have more than 32,000 rows in your second file?

Best regards

Mathias

[MarqueeCrew]

There is a limit to the number of records. I think that it will error. You would then need to put a constant value into each set of data and join using that constant 

[RodL]

Actually there is a dropdown at the bottom of the configuration of the Append Fields tool (that I have seen a few people miss) where it will "Allow All Appends" and won't error out.

That said, if you are trying to cross-join (which is essentially what an Append Fields tool does) 32,000 records with another 32,000 records, you'd end up with over a billion records...which may not be the intent of the join (which is why it is set by default to error if more than 16 records are in the "source" side of the join. 

[mathias_schnoor]

Thank you for your supports.

Of course you are right, over a billion records can not be the intent of a cross join!

Mathias