Problem in Loop

[soha1902]

Can any one tell me what is wrong in following code. it get executed without any error but did not populate any data in Fdate field.

FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate;
NEXT i;

[marcus_sommer · Accepted solution]

Try:

FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate Autogenerate 1;
NEXT i;

- Marcus

[soha1902]

Hi Marcus,

Thanks for your prompt answer

now this will fetched all records but in Fdate showing only 2 records. See screenshot

I want to show all the dates in Fdate field. Plz suggest.

Also can you let me know without autogenerate why it was not reloading any record?

[tamilarasu]

Simply try,

Tab:
Load  
  date($(vStartdate) + RowNo()-1) as TempDate  
AutoGenerate $(vEnddate) - $(vStartdate) + 1;  

[settu_periasamy]

that is problem with if($(i) = $(vStartdate) , this will be always true

FOR i = vStartdate to vEnddate

Tab:

Load $(i) as Fdate Autogenerate 1;

NEXT i;

[tresesco]

Try :

FOR i = vStartdate to vEnddate

Tab:

LOAD

         Date($(i)) as Fdate Autogenerate 1;

NEXT i;