Concate Strings from different Input Data Tools

mathias_schnoor

Hey!

I have two Input-Data Tools

Each Input Data Tool is connect on a csv-file. (CSV-File 1, CSV-File 2)

The first csv file (CSV-File 1) has one row, and the second csv-file ( CSV-File 2) has lots of rows.

It is possible in Alteryx to concate each row from  CSV-File 2 with a column the row from CSV-File 1

Example:

CSV-File 1

fistname; lastname

1;foo;  bah

CSV-File 2

text1;text2;text3

1; my fristname is; my lastname is

2, my fristname is; my lastname is

3; my fristname is; my lastname is

4; my fristname is; my lastname is

...

Result:

resulttext

1;my fristname is foo; my lastname is bah

2;my fristname is foo; my lastname is bah

3;my fristname is foo; my lastname is bah

4;my fristname is foo; my lastname is bah

Mathias

MarqueeCrew

Only a few edits.  When you have fields to append, they go to the Source input and get appended to the TARGET.  I also use the field configuration in the APPEND tool rather than have another SELECT on the canvas.  If you are making something STRING 500 bytes, you should have a VSTRING or VW_String type.  You may want to allow for the BIG string, but you don't want to always take that space. Using VARIABLE STRING gives you the flexibility.  I also got rid of those ROW ID fields because you didn't use them.

Tip:  If you are joining 2 sets of data that are in the EXACT same sequence (eg row ID), you can JOIN them using JOIN BY RECORD POSITION.  This is FASTER than by KEY.  If one has more records, than the other, those records will fall into either the L or R outputs.  Remember that the sequence of records must be identical.

Thanks,

Mark

mathias_schnoor_solution_MC.yxmd