Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Try:
FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate Autogenerate 1;
NEXT i;
- Marcus
Try:
FOR i = vStartdate to vEnddate
Tab:
LOAD
if($(i) = $(vStartdate),$(vStartdate),$(vStartdate) + 1) as Fdate Autogenerate 1;
NEXT i;
- Marcus
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?
Simply try,
Tab:
Load
date($(vStartdate) + RowNo()-1) as TempDate
AutoGenerate $(vEnddate) - $(vStartdate) + 1;
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;
Try :
FOR i = vStartdate to vEnddate
Tab:
LOAD
Date($(i)) as Fdate Autogenerate 1;
NEXT i;