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

[Harsha89]

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 solution]

Hi @Harsha89,

You can set the Join tool to join by position. 

Hope that helps,

Greg

[Maskell_Rascal · Accepted solution]

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

[Harsha89]

Thanks. I don't know why I could not think of this easy solution.