Blog

In ICE #9 “join4” we combine the join3 table and the customer master table using the variable CustID and in inner join. This results in a table with 1,168 observations. If we instead link this tables using a left join and the TerritoryID variable, we get a table with 18,937 observations. In this joined table, there are observations where the customerID from the join3 table does not equal the customerID from the customer master table. 

After cleaning data with Tableau Prep Builder, we can output the final cleaned data as a CSV file.

Which Alteryx tool have we used to create new variables and/or change the values of certain variables?

A patient needs to take 2.8 g of a drug Q8H. If each tablet contains a strength of 700mg, how many tablets should she take?

What Alteryx tool do we use when we want to stack two datasets with the same variables (but different observations)? 

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?