[Save table without headers] #qlik #qlikview #qliksense #script

qv-no-header-to-csv.qvs

// 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();