Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am using Qlick Cloud. I need to create a table which is made by a concatenation of tables, I am doing a for loop, my problem is that i think the FROM is not properly :
I get the following error:
set vRoot = 'lib://AttachedFiles';
FOR Each Ext in 'xlsx'
FOR Each File in filelist ('$(vRoot)'&'/get_user_course_report_*.'&Ext)
LOAD
subfield(Curso,' ',1) as curso_nombre,
subfield(Curso,' ',2) as itinerario,
Curso,
Usuario,
"Correo electrónico",
Horas,
"Generó certificado",
Aprobado,
"Avance en el curso",
etl_uid,
Puesto,
Empresa,
"Fecha alta",
"Nivel interno",
DNI,
etl_aparcamiento_lector_matricula,
etl_aparcamiento_sistema_control,
etl_aparcamiento_pame,
etl_aparcamiento_nombre,
Responsable,
Responsable_email,
Fecha_Baja,
Fecha_exportacion
FROM '$(File)';
next File
next Ext
try to add only one field which facing error?
The problem is that I dont know how to set the path since it does not reconize [$(File)] as the path, and I try many different ways to do that and it doesnt work....