Merge multiple spreadsheets, transformation tutorial

In this scenario, the manager wants to show the descriptions of the local promos in the final reports. The local spreadsheet does not have all the information on one sheet. So the next step is to create another merge between two sheets and create the MyPromos prepared source.

Using the same process as before, select the MyPromos_xlsx MyPromos and MyPromos_xlsx PromoCustomers sources, and merge them using the PromoID field as the inner join. Do not forget to hide the second PromoID column.

Click Apply.

Click Publish and Birst creates the two new prepared sources based on the definitions you created.