Last active
April 17, 2022 18:54
-
-
Save countnazgul/159214d0d670509c2a76 to your computer and use it in GitHub Desktop.
[Save table without headers] #qlik #qlikview #qliksense #script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Save QV table without the headers (or at least without the original headers) | |
set vNH_SourceTable = Data; // which QV table need to be exported | |
set vNH_OutputFile = C:\Users\adm-s7729841\Desktop\Headerless.csv; //the path to the result csv/txt file | |
Qualify *; | |
Headers: | |
First 1 | |
Load | |
* | |
Resident | |
$(vNH_SourceTable) | |
; | |
UnQualify *; | |
let vNH_Script = 'NoHeader:' & chr(10) & 'Load '; | |
for vNHi = 1 to NoOfFields('Headers') | |
let vNH_Column = FieldName($(vNHi), 'Headers'); | |
let vNH_ColumnVal = FieldValue('$(vNH_Column)', 1); | |
if $(vNHi) = 1 then | |
let vNH_Script = '$(vNH_Script)' & chr(10) & FieldName($(vNHi), 'Data') & ' as [' & '$(vNH_ColumnVal)' & ']'; | |
else | |
let vNH_Script = '$(vNH_Script)' & ', ' & chr(10) & FieldName($(vNHi), 'Data') & ' as [' & '$(vNH_ColumnVal)' & ']'; | |
end if | |
next | |
let vNH_Script = '$(vNH_Script)' & chr(10) & ' Resident Data '& chr(10) &' where RecNo() > 1'; | |
$(vNH_Script); | |
Store NoHeader into $(vNH_OutputFile) (txt); | |
Drop Table Headers; | |
Drop Table NoHeader; | |
let vNH_Column = null(); | |
let vNH_ColumnVal = null(); | |
let vNHi = null(); | |
let vNH_Script = null(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment