10.4 Append: Blinkit + Amazon Now
Append = stack tables with the same columns one below the other (like VSTACK, but refreshable and good for big data).
Steps in Excel
- Load both sources as queries:
Blinkit_OrdersandAmazonNow_Orders(Close & Load To… › Only Create Connection for each). - Make column names identical (e.g. rename Order Amount in Amazon Now to Amount, Locality to Area).
- Add a Platform column in each (Add Column › Custom Column
= "Blinkit"/= "Amazon Now") if not already present. - Home › Combine › Append Queries › Append Queries as New › Two tables (or Three or more) › select both › OK.
- Rename the new query
All_Orders› check row count = Blinkit rows + Amazon Now rows › Close & Load.
Worked example. Blinkit November file: 3,120 rows; Amazon Now: 1,680 rows (fictional). All_Orders: 4,800 rows. Columns that exist in only one file (e.g. Coupon Code in Blinkit) appear with null for the other platform's rows.
Ravindra Bagale's Tip
Append matches columns by name, not by position – "Amount" and "Order Amount" become separate columns and half the values come out null. Many students think the data has disappeared. Before appending, make the column names in both queries exactly the same (spelling, spaces, case).
Ravindra Bagale's Tip – मराठी
Append column नावाने जोडतो, position ने नाही – "Amount" आणि "Order Amount" वेगळे columns बनतात आणि अर्ध्या values null येतात. बऱ्याच students ना वाटतं data गायब झाला. Append च्या आधी दोन्ही queries मध्ये column नावं एकदम same करा (spelling, space, case).
Ravindra Bagale's Tip – हिंदी
Append columns को नाम से जोड़ता है, position से नहीं – "Amount" और "Order Amount" अलग columns बन जाते हैं और आधी values null आती हैं. बहुत से students को लगता है data गायब हो गया. Append से पहले दोनों queries में column के नाम बिल्कुल same करो (spelling, space, case).
Practice task
Append Blinkit and Amazon Now order queries after renaming mismatched columns. Verify the total row count and total amount against the two sources.