topic Re: Create For loop for 36 Months in App Development

Create For loop for 36 Months

Anonymous — Wed, 17 Jan 2018 14:56:40 GMT

Hello Guys,

Could you please let me know how do I create a

For loop for 36 months .

Thanks,

Ravi

Re: Create For loop for 36 Months

petter — Wed, 17 Jan 2018 16:32:40 GMT

In a load script you can create a FOR loop like this:

FOR month=1 TO 36

LOAD

AddMonths(MakeDate(2018,1,1),month-1) AS Month;

......

AUTOGENERATE 1;

In a visualization you can use the ValueLoop()-function to generate within an expression:

AddMonths(MakeDate(2018,1,1), ValueLoop(0,35)) // to be used for instance in a calculated dimension.

Re: Create For loop for 36 Months

Anonymous — Sun, 21 Jan 2018 19:41:27 GMT

Thanks for replying Petter ,

FOR month=1 TO 36

I have to use column name like Duration. How do I use this column DURATION instead of 1 to 36 . ?

DURATION column has value of 36 . So I want For loop starting from 1st month to 36th month.

So I need something as mentioned below .

FOR x=1 to "DURATION"

Thanks,

Ravi

Re: Create For loop for 36 Months

petter — Sun, 21 Jan 2018 20:52:00 GMT

So the Duration belongs to a table with many rows right? Do you want 36 times the number of rows? Need to know more about the table structure you have and what kind of table structure you need to produce....

Re: Create For loop for 36 Months

Anonymous — Sun, 21 Jan 2018 21:49:53 GMT

hello ,

here is my code :-

[DataNew1]:

LOAD

"Product Line",

"Impact month",

"Duration"

FROM [lib://AttachedFiles/Complexity_Mix.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Model);

FOR month=1 TO 36 (Here 36 is the value in Column "Duration" ) , This value may change so I wanted it to be dynamic.

So I want For loop starting from 1st month to 36th month.

FOR x=1 to "DURATION" , I want to use column name in the FOR LOOP not the numbers .

Thanks,

Ravi

Re: Create For loop for 36 Months

petter — Sun, 21 Jan 2018 22:11:52 GMT

So what will be the variation for each of the 36 months? One monts difference? Anything else?

Re: Create For loop for 36 Months

petter — Sun, 21 Jan 2018 22:20:52 GMT

You can use while to iterate a number of times and produce many rows:

[DataNew1]:

LOAD

"Product Line",

AddMonths("Impact month",IterNo()-1) AS Month,

"Duration"

FROM [lib://AttachedFiles/Complexity_Mix.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Model)

WHILE IterNo()<=Duration;

I assume here that "Impact month" is a real date and not just a mont number or month name...

Re: Create For loop for 36 Months

Anonymous — Sun, 21 Jan 2018 22:26:00 GMT

Yes Yes one month difference .

Re: Create For loop for 36 Months

Anonymous — Sun, 21 Jan 2018 22:43:48 GMT

Thanks ,

Could you please Use FOR LOOP ?

Re: Create For loop for 36 Months

petter — Mon, 22 Jan 2018 07:50:48 GMT

That's exactly what I did in my very first response. If you tell us what your source table and result table should look luke it would be easier to give a good suggestion or solution.

Re: Create For loop for 36 Months

Anonymous — Mon, 22 Jan 2018 09:13:56 GMT

Thanks Petter,

[DurationFlow3]:

Load

"Impact month", // has value of 12

"Duration" // has value of 4

FROM [lib://AttachedFiles/Complexity_Mix.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Model);

Let vImpact_Month=Peek('Impact month',0,DurationFlow3);

For i=1 to 36

For x=1 to 4 // here I want ( For x= 1 to Duration) from table [DurationFlow3]: Rest all code is fine for me , Just need this for loop ...

if $(i) =1 then

test:

load

$(i) as Month,

$(x) as Month2,

$(vImpact_Month) as value

AutoGenerate 1;

ELSE

test:

load

$(i) as Month,

$(x)+($(i)-1) as Month2,

$(vImpact_Month) as value

AutoGenerate 1;

ENDIF

NEXT x;

NEXT i;

Re: Create For loop for 36 Months

Anonymous — Mon, 22 Jan 2018 09:25:06 GMT

Thanks Petter ,

I was able to Solve the issue . I did something like this and it worked for me .....Thanks a lot for the support , I appreciate your suggestions

let vDuration= Peek('Duration',0,Duration_table);

for x=1 to $(vDuration)