Wrangle your Data

Perfom basic data transformation to clean your data

How to copy a column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On preview...
Thu, 24 Dec, 2015 at 3:16 PM
How to merge two columns?
You can merge two column or column and a value and create a new column out of it. The steps to follow are - Step 1: When you create a new connection,...
Sat, 14 Mar, 2015 at 4:54 PM
how to do a lookup on a column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On preview...
Thu, 24 Dec, 2015 at 3:36 PM
How to remove duplicate records?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On preview s...
Sat, 14 Mar, 2015 at 6:03 PM
how to delete a column?
You can delete a column in two ways -   1) By using suggestions on right panel   Step 1: When you create a new connection, for example as s...
Thu, 24 Dec, 2015 at 3:22 PM
how to remove null values from a column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On preview s...
Sat, 14 Mar, 2015 at 6:12 PM
how to cut within a column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On p...
Thu, 24 Dec, 2015 at 4:01 PM
See Data Quality Charts
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On p...
Thu, 24 Dec, 2015 at 4:04 PM
How to rename a column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen.   Step 2: On prev...
Wed, 11 Mar, 2015 at 11:46 AM
How to know the Data type of column?
Step 1: When you create a new connection, for example as shown here in Connect To hadoop article, you will get to Preview Screen. Step 2: On preview s...
Thu, 24 Dec, 2015 at 4:20 PM