Append Two Tables If Index is above a certain value

[tabuzahra]

Hello,

I have created an index for each row in (Table 1) to give row a number to compare with (Table 2) where it has the same columns.

I'm wondering if it's possible to append (Table 2) to (Table 1) only if the index in (Table 2) is more than 25000.

FYI (Table 2) has more rows than the (Table 1).

I would really appreciate your support

[v-diye-msft · Accepted solution]

Hi @tabuzahra 

Did you try to remove the 1-25000 rows in table2 before you append the tables?

Below is the sample I created:

I removed the top 3 rows in table 2:

Then append the 2 tables: