File Query 2
Unix Launcher
Download File Query 2
Download Unix Launcher
Go to the support section for documentation, and additional help information

What is File Query

File Query is the simplest and easiest way to quickly view, query, analyze and modify flat (plain-text) data files of any type. See for yourself by downloading a free 30-day trial now, or see what your colleagues are saying on LinkedIn.

"..find the records you need, just as if it was in a database."

Key Features

  • Open and view files of any size, and immediately be able to view and work with them. No need to import anything first.
  • Spread all of the fields of a delimited file into even, easy to read columns. You will never want to look at a delimited file any other way.
  • Easily query files to find the records you need, just as if it was in a database.
  • Quickly profile files, getting frequency counts, min/max length, character types and more from each field.
  • Modify layouts, such as adding and removing fields, or changing the delimiter. Did the client send a file with an extra field that is throwing off your load job? Just remove it.

"..find possible data issues immediately...

Use Cases

  • When a new feed coming in, you can run a single report that will profile all fields throughout the entire file. This allows you to find possible data issues immediately, such as:
    • unique fields having dupes
    • fields being too long
    • numeric fields containing non-numeric characters
    • required fields having missing values.
    Spec out the data faster and more accurately, saving development time as well.
  • When jobs break due to bad data, especially during the load to the database, it can be very difficult to find the cause. How do you check the data in a large flat file? File Query gives you that ability, allowing you to immediately find the data that is causing the issue. You can find all records where a field is:
    • too long
    • contains the wrong type of data
    • has a duplicate value
    • is empty
    • has an invalid value
    This allows you to tell if the issue is truly caused by bad data, or perhaps that database and job not being able to accept all valid values.
  • When reading in files to the database, or writing them out from the database, File Query makes it easy to validate that everything was moved correctly. Normally, if you load a 200 field file, and many of the fields are empty in the database, how do you know if that is because they were empty in the file, or the fields were not mapped correctly? With File Query, you won't have to guess.
  • Viewing the format of fields becomes easier when you can view a delimited file as even columns, making the data clearly readable.


User Interface Normalize Fields in Preview

Preview Video

kate spade green monday deals kate spade green monday michael kors super saturday moncler green Monday 2014 michael kors super Saturday michael kors green Monday deals burberry green monday sale beats by dre green Monday moncler green Monday 2014 burberry green Monday michael kors green monday sales moncler green Monday deals beats by dre green monday sale uggs green monday Hollister green Monday beats by dre green Monday 2014 canada goose green monday deals beats by dre green Monday uggs green monday coach green Monday burberry green monday moncler green Monday north face green monday 2014 burberry green Monday 2014 michael kors green Monday lululemon green monday beats by dre green Monday canada goose green Monday 2014 coach green Monday sale michael kors green Monday sales burberry green Monday 2014 north face green monday 2014 beats by dre green Monday lululemon green Monday uggs super Saturday 2014 Hollister green monday coach green Monday sales uggs super Saturday michael kors super Saturday 2014 uggs super saturday