Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to create a loop while loading data that it should take only last 4 weeks of the data into app.Where my qvd names are created as shown below:
Hi @QVUser1
Try like this below:
FOR EACH vFile IN FILELIST ('lib://Test/CountrySales_*.qvd')
IF(num(DATE#(TextBetween(vFile,'_','.'),'YYYY-MM-DD')) >= TODAY() - (4*7)) THEN
Data:
LOAD *,
FileName('$(vFile)') as QvdName
FROM [$(vFile)](qvd);
END IF
NEXT vFile
What is this vFile is this any variable .if so what should we declare in it.