Defining Export Specification

  1. Click on Entity.

    The entity view displays the Candidate fields and relations.

  2. Click General tab.
    1. Verify Locale is English.
    2. In Export mode select CSV-report from pull down menu.
    3. Check CSV header present.
    4. Check CSV value delimiter and enter comma (,).
    5. Check CSV quotation character and enter double quote (“).
  3. Click Projections tab.
  4. Drag and drop EmailAddress from the Entity Structure to the Projections list.
  5. Click Add
    1. Select Add a function projection.
    2. Select Concatenate from the Function pull down menu.
    3. Click OK.
  6. In Alias enter FullName
    1. Drag and drop LastName from the Entity Structure to the Function parameters list.
    2. Select LastName and move to top with up arrow.
    3. Select second parameter.
    4. Select String from Data type pull down menu.
    5. Enter a comma followed by a space (, ).
    6. Select last parameter and delete with minus icon.
    7. Drag and drop FirstName from the Entity Structure to the Function parameters list.
  7. Click Filters tab.
    1. Drag and drop EmailAddress from the Entity Structure to the Filters list.
    2. Click Filter (Equal) in the Filters list.
    3. Verify first value is EmailAddress.
    4. Verify first Data type is Field.
    5. Verify Operator is Equals.
    6. Enter psmith@abc.com in second Value.
    7. Verify Second Data type is String.