hello all,
I know we can append one field to another using the Append Fields tool. My question is how to stack multiple fields coming from multiple streams (field A from stream A, field B from stream B, etc...) , horizontally at once (instead of using append tool multiple times)? all these fields have one row only.
One way I can think of is to add a helper column to each of these fields respectively, and use the Join Multiple tool (join by that helper field). Wonder if there's quicker/easier way?
Thanks.
Solved! Go to Solution.
Hello @rzz0419999
As your data comes form different sources you will need to you one of the Join tools. One additional way will be to union all the data based on position, as there is only 1 cell they will stack up on each other and then you can use the Cross Tab tool. Or you can use RecordID as your helper column from above and then join it based on the RecordID which will be always 1.
Thanks so much.
Join Multiple will do this, with the selection "Join by record position"