Forum Discussion
Appending issue
HI thampton,
Not sure if I'm getting your issue correctly, you refer that you are appending 2 tables, so the final result is a single table with all the rows of the tables you are appending, if each of the tables have 1 row you will get 2 rows.
Another thing to have in mind is that in order to make appends both table need to have the same name in colums if you have different names you will get adittional columns in your final table.
Example:
Both tables with same name columns
Table 1 Column 1 Column 2 A 1 Table 2 Column 1 Column 2 B 2 Final Table Column 1 Column 2 A 1 B 2 Both tables with different name columns:
Table 1 Column 1 Column 2 A 1 Table 2 Column 1 Column 3 B 2 Final Table Column 1 Column 2 Column 3 A 1 null B null 2 So you will get different results, what do you want to achieve?
Regards,
MFelix
HI thampton,
Not sure if I'm getting your issue correctly, you refer that you are appending 2 tables, so the final result is a single table with all the rows of the tables you are appending, if each of the tables have 1 row you will get 2 rows.
Another thing to have in mind is that in order to make appends both table need to have the same name in colums if you have different names you will get adittional columns in your final table.
Example:
Both tables with same name columns
| Table 1 | |
| Column 1 | Column 2 |
| A | 1 |
| Table 2 | |
| Column 1 | Column 2 |
| B | 2 |
| Final Table | |
| Column 1 | Column 2 |
| A | 1 |
| B | 2 |
Both tables with different name columns:
| Table 1 | ||
| Column 1 | Column 2 | |
| A | 1 | |
| Table 2 | ||
| Column 1 | Column 3 | |
| B | 2 | |
| Final Table | ||
| Column 1 | Column 2 | Column 3 |
| A | 1 | null |
| B | null | 2 |
So you will get different results, what do you want to achieve?
Regards,
MFelix
