Append fields with differing row count

[fardeen9983]

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

[christine_assaad · Accepted 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!

[bpatel · Accepted solution]

hi @fardeen9983 ,

you're on the right track! the append fields will help you achieve 100 x 1000.

hope this helps!

[JagdeeshN · Accepted solution]

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