Procedure
-
Double-click tFixedFlowInput to open its
Basic settings view in the Component tab.
-
Create the schema through the Edit Schema
button.
In the open dialog box, click the plus button and add the columns that will hold the information in the input address, in this example: address_input, COUNTRY and data_description.
- Click OK.
- In the Number of rows field, set the number of rows as 1.
- In the Mode area, select the Use Inline Content (delimited file) option, and set the row and field separators in the corresponding fields.
-
In the Content table, enter the address data
you want to analyze, for example:
Boise Town Square 421 N Cole Rd 83704,,wrong data Boise Capitol 280 S Capitol Blvd 83702,us,both address coutry correct Federal Way 3563 South Federal Way 83705,US, both correct Salmon Creek In-Store (ALB) 14300 NE 20th Ave Ste.B-101 Vancouver WA 98686,US,both correct Battle Ground 2500 West Main Street,,no country;address miss(Battle Ground WA 98604 ) Battle Ground 2500 West abcd Street,,no country address changed south southjkjkjkjkjkj,,wrong data