VERIFIED SOLUTION i
X

Resolve unexpected result using quote in flat file source transform of Sagent

Issue

While reading the input file, if the Flat file source transform gets special characters such as quotes, the plan fails or output gets truncated after the special character.

Cause

This issue can occur possibly due to any of the following reasons:
  • Unexpected data.
  • Incorrect setting in the Quote section of Attributes tab.

Resolution

UPDATED: August 14, 2017


To resolve the issue, try the following:
  • Check the data for any unexpected input.
  • Ensure that the quote expected to be present in the input file (single or double) or which is required to be truncated, is selected in the 'Quote' section of 'Attributes' tab. If '<<NONE>>' is selected, no truncation is done and it passes the value along with the quotes.
  • Ensure that 'Detect Columns' button in the columns tab is pressed otherwise the data after quote gets truncated.
User-added image

If the issue remains unresolved, contact Client Support.

Environment Details

Product Feature: Flat File Source Transform

Downloads

  • No Downloads