Creating QVD Looping Problem

Wed, 19 May 2010 18:03:27 GMT

Hey if someone could please help me with this code bit that is simply not working

MY goal is to loop through each list projects (ie in the variable ProjectName) and store them a specific file. So right now I only have one. So my goal in this case is to load from SP2 Project Sample.xml and then take the table Field_Table and store it in c:\LANDESK\TEST\CurrentDateField_Table.qvd . Below it is storing it in c:\ so any help is appreciated

thanks, Jason

The Code:

SET Directory[1] = c:\;
SET ProjectName[1] = SP2 Project Sample.xml;
SET ProjectPath[1]=LANDESK\TEST;
LET ProjectCount=1;
LET CurrentDate = date(today(),'YYMMDD');

for a = 1 to ProjectCount
//LOAD all tables in to QVDs based on a filename convention of FileName and Current Date
Field_Table:
LOAD
$(CurrentDate) as Field_Table.CurrentDate,
FieldID,
FieldName,
Alias,
Guid
FROM [$(Directory$(1))$(ProjectPath(1))\$(ProjectName$(1))](XmlSimple, Table is [Project/ExtendedAttributes/ExtendedAttribute]);
SET FileName = $(CurrentDate)Field_Table.qvd;
STORE Field_Table INTO [$(Directory(1))$(ProjectPath(1))\$(FileName)];
DROP TABLE Field_Table;
next a

topic Creating QVD Looping Problem in QlikView

Creating QVD Looping Problem