Append fields with differing row count

Question

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 Answer

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 Answer

hi @fardeen9983 ,

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

hope this helps!

JagdeeshN · Accepted Answer

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