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