Test Drive Scenario
Here is a sample scenario to test out the Wrangler in your environment
Log into Microsoft Fabric: Go to app.fabric.microsoft.com
Add a Lakehouse and create the destination table.
Below is a sample Lakehouse table schema for the scenario. The SQL script is run in a notebook, which will generate your table. Note that there are various methods for creating a schema.
%%sql
CREATE TABLE Sales_Orders_Sample (
Customer_Name STRING,
Company STRING,
Order_Date DATE,
Order_No STRING,
Part_Classification STRING,
Part_Name STRING,
Qty INT,
Price STRING,
Address STRING,
City STRING,
State STRING,
ZipCode STRING,
Phone STRING,
Notes STRING
) USING DELTA;
Upload your Source data file(s) to the Lakehouse
Below are two sample files to run through your Wrangler.
Below are sample instructions
If the Order Date field is blank, set the date to 01/01/1900
Remove $ from the Price.
Extract or Infer City, State, and Zip Code from Address
Phone number should be in (XXX) XXX-XXXX US Phone number format. You can skip the country code
Part Classification can only take one of these two values. Figure out how to map any values in the source to one of these five values.
Product
Service
Last updated
Was this helpful?