I have two different record sources one with 99 fields and around a 1000 rows. The other one is a 1X1 text input. I want to combine them using Append field or whichever tool can be used for this, so that the result is 100 X 1000 records where the last field is just the repetition of the Text Input
Solved! Go to Solution.
Hi @fardeen9983
Is the attached what you are looking for? I generate rows just to generate 1000 rows but this could be replaced by your data. Cheers!
hi @fardeen9983 ,
you're on the right track! the append fields will help you achieve 100 x 1000.
hope this helps!
Hi @fardeen9983 ,
Like @bpatel mentioned you can use the append tool to get this done.
Alternatively you can also use the join tool to achieve the same result.
Please find the logic for both option in the attached workflow.
Best,
Jagdeesh Narayanan