Ravindra BagaleCourses & study guides

10. Power Query in Excel

10.4 Append: Blinkit + Amazon Now

By Last updated:

Append = stack tables with the same columns one below the other (like VSTACK, but refreshable and good for big data).

Steps in Excel

  1. Load both sources as queries: Blinkit_Orders and AmazonNow_Orders (Close & Load To… › Only Create Connection for each).
  2. Make column names identical (e.g. rename Order Amount in Amazon Now to Amount, Locality to Area).
  3. Add a Platform column in each (Add Column › Custom Column = "Blinkit" / = "Amazon Now") if not already present.
  4. Home › Combine › Append Queries › Append Queries as New › Two tables (or Three or more) › select both › OK.
  5. 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 column naavane jodto, position ne nahi – "Amount" aani "Order Amount" vegle columns bantat aani ardhe values null yetat. Khup students la vatata data gayab zala. Append chya aadhi donhi queries madhe column nava ekdum same kara (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.