Discussion Board for collaboration on QlikView Scripting.
Is it possible to create a text file with some message in it such as 'No Data Received' and store it at some location?
When some codition fails then in the else part i want a text file to be created with this message
Go to Solution.
In else part write this
Load * inline
'No Data Received'
store File into File.qvd(txt);
yes you can use execute cmd lines to write files to certain locations like that, or out as an email rather than a txt file for example
Yup. Create a table with an InLine load and store it in txt format, as opposed to qvd format.
Yes it is possible try this code
Tab://Suppose it is table with zero rows
LOAD * Inline
LET vNoOfRow = NoOfRows('Tab');
If $(vNoOfRow) = 0 Then
No Data Received
STORE Status into Status.txt(txt);
Note:- and in second reload put some values and try to reload you not get any field generated
You can load your table like below script to get the current date and time also
'No Data Received on '&Now() as Status