Loop in Script

Anonymous — Tue, 22 Mar 2016 14:22:26 GMT

Hiya All

Something New...Loops

I have the following in a script and want to loop and say

Per Dimension Count ( Distinct(Acct)) where Dimension is greater than 0

The following numbers below are field names not values, although they contains values.

I am inner joining this to a Group

So example

LOAD Acct,

[0],

Count(Distinct(Acct)) where [0] > 0 as Current Month

[1],

Count(Distinct(Acct)) where [1] > 0 as Month1

[2],

[3],

[4],

[5],

all the way to 72!

Re: Loop in Script

Chanty4u — Tue, 22 Mar 2016 14:24:23 GMT

so what do you want?

expected output?