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
Solved! Go to Solution.
Hey!
I had found the Appand Fields Tool on myself!
Is the an other solution?
Mathias
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
Hey MarqueeCrew,
thank you for your support.
Mathias