Append single row table to an existing table without duplicating the added row

Question

I am trying to add a single row table to a table with multiple rows but do not want the new added row to repeat for each line of the original table

Taking this example from an earlier post here :

Table 1 (multiple rows):
1 | A
2 | B
3 | C
4 | D
5 | E

Table 2 (single row):
ABC | DEF

Expecting result:

1 | A | ABC | DEF
2 | B
3 | C
4 | D
5 | E

Greg_Murray · Accepted Answer

Hi @Harsha89,

You can set the Join tool to join by position.

Hope that helps,

Greg

Maskell_Rascal · Accepted Answer

Hi @Harsha89

There are a couple different ways you can go about this. It sounds like you just want the single row to be appended to the first row of your existing data. If that's the case, attached are a couple different ways you can accomplish this with either the Append Tool or Join Tool.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil