Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings from Freiburg in SW Germany!
I want to store a table in QV/QS in a text file format, like this:
STORE Test INTO [..\DATA\PROFIS\ERGEBNISSE\$(vPraefixDateiName)-test_ohne_header.txt](txt,delimiter is ';');
If I do so, Qlik will store also the header (name of the columns), like in the screenshot bellow:
I want to store the table without the first line containing the header (column names, separated by 😉
Many Thanks in advance!
Alexandru
you may give a try by running the script by using Execute command.
but we dont have direct feature
As far as I know, that's not an option from within the script. You might be able to achieve something like this using Automations in SaaS. As a possible workaround in the script, you could peek at the first value of each field, use that as the field name for a separate load where you read everything *except* the first line, and then Store that. You'd end up with the first line replacing the header row, which I think would achieve the same thing as storing without the header?
Thank your for your answer.
We use Qlik on premise.
I understand your workaround, yet it would cost me to much time to write the code. I am speaking about 60 Tables from SAP FI, and each table has sometimes a few dozen of fields...
Do you have be accident a sample code for this?
you may give a try by running the script by using Execute command.
but we dont have direct feature
I had a similer project with the same issue. I solved with the execute command and using some DOS-commands
Beside this you may do it with less code in Qlik with something like: