Append#
Description:
Appends (Unions) on table to another.
Function:
Append(table = string, append_table = string, new_table_name = string)
Parameters:
Table: Table name on which to perform function
Append Table: Table to append to the parameter Table
New Table Name: Name of the new table
Example:
Append(table = Budget, append_table = Budget_2, new_table_name = "Appended Table")
Date |
Geo |
Business |
Plan |
Actual |
|---|---|---|---|---|
5/1/2024 |
Latin America |
Energy |
900 |
-900 |
5/1/2024 |
Latin America |
Manufacturing |
1050 |
1100 |
6/1/2024 |
Latin America |
Manufacturing |
2000 |
-1800 |
Date |
Geo |
Business |
Plan |
Actual |
Delta |
|---|---|---|---|---|---|
7/1/2024 |
Middle East & Africa |
Healthcare |
1200 |
900 |
-300 |
7/1/2024 |
Middle East & Africa |
Healthcare |
1150 |
1000 |
-150 |
8/1/2024 |
Asia-Pacific |
Energy |
800 |
750 |
-50 |
8/1/2024 |
Asia-Pacific |
Technology |
950 |
1050 |
100 |
9/1/2024 |
Asia-Pacific |
Technology |
1500 |
1300 |
-200 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
-300 |
Date |
Geo |
Business |
Plan |
Actual |
Delta |
|---|---|---|---|---|---|
5/1/2024 |
Latin America |
Energy |
900 |
900 |
|
5/1/2024 |
Latin America |
Manufacturing |
1050 |
1100 |
|
6/1/2024 |
Latin America |
Energy |
1850 |
2000 |
|
6/1/2024 |
Latin America |
Manufacturing |
2000 |
1800 |
|
7/1/2024 |
Middle East & Africa |
Healthcare |
1200 |
900 |
-300 |
7/1/2024 |
Middle East & Africa |
Energy |
1150 |
1000 |
-150 |
8/1/2024 |
Asia-Pacific |
Energy |
800 |
750 |
-50 |
8/1/2024 |
Asia-Pacific |
Technology |
950 |
1050 |
100 |
9/1/2024 |
Asia-Pacific |
Technology |
1500 |
1300 |
-200 |
9/1/2024 |
Asia-Pacific |
Energy |
1700 |
1400 |
-300 |