Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am New In Qlikview..I want to Know About Loop(For loop)......With Example...Qvw File.......Where We Use For Loop...And Why We Use.....What Is Reason Behind It For Using Loop........How Would I know That I am Use LOOP........With Example
there could be lots of reasons to have a loop, the logic is to reiterate an operation more than one time, in the following example I have to concatenate files into one table doing some check
let path_Alles = '..\Allestimenti\pagella_cliente_Allestimenti_*.xlsx';
for each File in filelist (path_Alles)
IF(left(right(File,11),4)<=$(currYear)) then
PalletInfo:
LOAD
'PalletInfo' as TableOrig,
if(Len([Reference Client])<>10, Repeat('0',10-Len([Reference Client])) & [Reference Client],[Reference Client]) as shipto_code,
'PALLET' as type,
Upper(Trim(Subsubcategory)) as competitor,
[WEEK UPDATE] as dataAlles,
[sold to] as customer_code,
[Allestimenti Samsung: Quantità] as palletinfo_qty,
'-' as pallet_material,
0 as palletinfo_prezzo,
'-' as palletinfo_serie,
'1' as datoAssoluto
FROM $(File) (ooxml, embedded labels, table is Display)
Where [WEEK UPDATE] >= 201223 and [WEEK UPDATE] <= 201240 and [Product (short)] = 'PALLET';
ENDIF
next File
Hi
Please refer
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
there could be lots of reasons to have a loop, the logic is to reiterate an operation more than one time, in the following example I have to concatenate files into one table doing some check
let path_Alles = '..\Allestimenti\pagella_cliente_Allestimenti_*.xlsx';
for each File in filelist (path_Alles)
IF(left(right(File,11),4)<=$(currYear)) then
PalletInfo:
LOAD
'PalletInfo' as TableOrig,
if(Len([Reference Client])<>10, Repeat('0',10-Len([Reference Client])) & [Reference Client],[Reference Client]) as shipto_code,
'PALLET' as type,
Upper(Trim(Subsubcategory)) as competitor,
[WEEK UPDATE] as dataAlles,
[sold to] as customer_code,
[Allestimenti Samsung: Quantità] as palletinfo_qty,
'-' as pallet_material,
0 as palletinfo_prezzo,
'-' as palletinfo_serie,
'1' as datoAssoluto
FROM $(File) (ooxml, embedded labels, table is Display)
Where [WEEK UPDATE] >= 201223 and [WEEK UPDATE] <= 201240 and [Product (short)] = 'PALLET';
ENDIF
next File