Hi Denodo Team,
I have a job on the scheduler server running a query, and creating a CSV file with the result of the query.
But, in case of a specific field contains NULL values, then the file should be generated as empty.
Wthat I have done is to split current job in two ones:
- The first one generates the file as before...I have added on the Where clause "and FIELD is not null".
- The second one is the opposite, it should create a file in case that "FIELD IS NULL" but, it writes into the file all the rows containing this field populated as null.
My question is...Is there any way to generate just an empty file, without writing anything in it, in the second scenario?
I would need just to create an empty file, with no data in it in case of nulls... is it feasible?
Thanks in advance.