Looping through sub fields

Anonymous — Fri, 20 Feb 2015 14:58:16 GMT

i have 3 subfolders in a directory path

C\test

in test there are folder1-prj,folder2-prj,folder3-prj

now i want to loop through these folders and run the following script

EXPRESSIONDATA:

Load

%Key_Data_7EB7522AE0A7D03B

ExpressionID,FilePath() as NameID

[ExpressionVisual/Label/v]

ExpressionName

[ExpressionData/Definition/v]

ExpressionCalc

[ExpressionVisual/Label/v]

&': ' &[ExpressionData/Definition/v]

Expression

REPLACE

(REPLACE

('$(File)','$(SubDirectory)',''),'.xml','') as

ObjectID

FROM

[$(File)] (XmlSimple

, Table

[GraphProperties/Expressions/ArrayOfMainExpressionData/MainExpressionData/Data]);

CHARTDATA:

Load

[ChartProperties/Title/Title/v]

ChartTitle

[Dimensions/ChartDimensionDataDef/PseudoDef/Name]

DimensionCalc

[TableProperties/ExpansionInfo/ExpansionData/Pos/DimName]

DimensionName

REPLACE

(REPLACE

('$(File)','$(SubDirectory)',''),'.xml','') as

ObjectID

FROM

[$(File)] (XmlSimple

, Table

[GraphProperties]);

left

join

(CHARTDATA) load

ObjectID

,replace

(ObjectID

, 'CH','') as

CHTID

, concat

(distinct

DimensionCalc

) as

DimensionsConcat

REsident

CHARTDATA group

ObjectID

;

left

join

(EXPRESSIONDATA) load

ObjectID

concat

(distinct

Expression

' ) as

ExpressionsConcat

REsident

EXPRESSIONDATA group

ObjectID

;

if i run it in one of the subfolders it works well but i want to be able to loop through all the subfolders

Re: Looping through sub fields

giakoum — Fri, 20 Feb 2015 15:04:19 GMT

not sure what your problem is.

Why don't you use a for next statement to loop through all sub folders?

Re: Looping through sub fields

Gysbert_Wassenaar — Fri, 20 Feb 2015 15:06:59 GMT

You can find code to (recursively) loop through subdirectories here: loop through to load all files from a folder and its subfolders? You will want to replace the load code from the example with your code.

topic Re: Looping through sub fields in QlikView

Looping through sub fields

Re: Looping through sub fields

Re: Looping through sub fields