Blog

In ICE #9 “join2” we left join our “join1” table and the customer invoices table using the InvoiceID variable. If instead we use a inner join, we find that 1 observation is excluded from the join1 table. This means that there must be a sales order from join1 where InvoiceID is null. 

The term used to describe the loss of propellant from the metering valve of and MDI is ?

If you want to identify which customers do not have orders, you should use an inner join. 

What delimiter is recommended by the AICPA in its Audit Data Standards as a preferred delimiter for files provided to auditors?

There are several ways to administer an SVN treatment to a patient. Which way is NOT recommended for any patient population?

Which of the following statements regarding unique identifiers are true? Check all that apply. 

When using the Summarize tool, only one variable can be designated as the “group by” variable.  

What are various ways the the data cleanse tool can be used within Alteryx? Select all answers that apply. 

In ICE #9, If we “full join” KMPG’s Sales Order file with Shipments file using Sales Order ID, we keep the records (observations) that are only in both Sales Order file and Shipments file.

In the KPMG revenue case (ICE #9), we first filtered observations for shipments made in 2017 and the “aggregated” sales transactions by TerritoryID, Shipping Month, and whether the sale is related to the new product (#7123).  We then outputted this data as a csv file. The grouped data has 5*12*2 = 120 observations.