How do you export a file with a '|' pipe/bar separated output?
I have specific requirement of exporting a report from QV which should be '|' pipe/bar separated output? I know comma, semicolon and tab options are available.
All you need to do is create a table with the required fields in the script and then use:
[QV Report]: load
field1
,field2
,etc
resident [FACT TABLE]
;
store [QV Report] into C:\Users\Ronak\Documents\QV Reports.txt (txt, delimiter is '|');
drop table [QV Report];
This will creat the table and save all fields of the table QV Report as a text document with a pipe seperator. The folder location can be changed to point it to the desired location and you can use relative paths (..\..\..\QV Reports.txt). And then the reporting table can be dropped afterwards.
If this answer was correct, please mark it as correct so that it isn't displayed as unanswered, and hopefully it can help others with the same question.
