Zia-powered data cleansing capabilities

• Filter the data in a sheet. Only the filtered data will be imported into the application.
  
• Find & Replace data
  
• Perform data-cleansing operations in the sheets, which are grouped under the Refine Data option:
  
• Fix inconsistent spellings
  
• Fix missing values
  
• Split the data in a column into two by defining their delimiter
  
• Merge columns
  
• Explore the frequency distribution of values in a column
  

Importing subform data

1. Select the sheet that contains its parent data. This'll become the parent or main form after the import operation. Let's call this the "parent sheet".
   
2. Select the column in the "parent sheet" that identifies each row uniquely.
   
3. Select the column that's the parent row identifier in the current sheet (which you're marking as subform)
   

Importing name and address data

Spreadsheet app-like import interface

• View the data in all the rows in the sheets
  
• Sort the data in your sheets. (This sorting won't be applied in the app you create. It's only to let you view the data in the required order.)
  
• Delete rows
  
• Undo and redo actions