Status: Closed (View Workflow)
Affects Version/s: 220.127.116.11_2
Component/s: Query Engine
If a column value is blank, it is excluding it in the result, causing incorrect output.
DELIMITER '|' QUOTE '"'
In the above example, if middle name is blank, then it should still show one empty column with "|" delimiter as shown below.
But it returns output as excluding middle name since it is blank.