Transformaton validation Error"index was the outside boundry of array"

[Former Member]

Hi Henry and formu experts.

Good day

i have seen you quesation on the forms, i am getting the same error "index was the outside boundry of array"

but i am getting this error whichle i am trying to vladiate and process the transformation.

below is the sample data

year,forecast,entity,deprtment,account,2010.01,2010.02,2010,03,2010.04

2010,forecast,270,99,370,-2701,-2230,-7182,4467

the problem here is i dont have headder for the time, headder is time formate , i tried to use MVAL(6:10), but still its giving the same error.

then i tried with below data formate.

year,forecast,entity,deprtment,account,Time

2010,forecast,270,99,370,2010.01,-2701

its successfully validated and processed the transformation. But i dont know how to resolve the issue with the first data formate.

If anyone had the same issue or know the sollution pls advice me how to resolve the error.

Thanks inadivence

Regards

Narsi

CQS Performance sollutions

0787082639

[JohnL]

Try using MVAL(6:9) instead. You only have 9 columns in your data file correct?

-John

[Former Member]

Hi

i am trying to use the below statement . its giving error . pls have a look

*SELECT(%YEAR%,"[YEAR]","T_TIME",u201D[ID]=%T_TIME_SET%u201D)

*SELECT(%PYEAR%,"[YEAR]-1","T_TIME",u201D[ID]=%T_TIME_SET%u201D)

*RUNALLOCATION

*FACTOR=1

*DIM T_MOVEMENTS WHAT = CB; WHERE=OB;

*DIM T_TIME WHAT=MAR.%PYEAR%; WHERE=BAS(TOTAL.%YEAR%)

*ENDALLOCATION

*COMMIT

The resule

Validation status of executable file: Failed

- Incorrect syntax near 'u201D'. in:select [YEAR] from mbrT_TIME where u201D[ID]=%T_TIME_SET%u201D

Validation status of syntax: Failed

- Invalid syntax found; see statements in red

Bud if specify the year its running properly. pls advice me whare i was wrong

Thanks