please some one help me with this Issue...

[#1]

I am trying to create table but I am getting Syntex Error can anyone please help me out from this Issue..

Syntax error, missing/misplaced FROM:
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY,
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY,
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)

[#2]

hello

Erase the ' , ' before FROM

regards!

[#3]

also you are missing a ' ; ' at the end of the load statement

[#4]

I am trying to do as you told me beofre but I am getting this Problem agian..,how do I fix this error..,

Unknown statement
OverviewMeasureFormula

LOAD
MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1)

[#5]

Hi, try this

OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
[MeasureOverAvg co-pay],
[MeasureOverMedian co-pay],
[MeasureOvermode co-pay],
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);

[suniljain]

Remove ',' From both load statement.

[#7]

Hi Shiva ,

Load this code

OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);
OverviewMeasureFormula:
LOAD MeasureName as %MeasureName,
MeasureOverAvg co-pay,
MeasureOverMedian co-pay,
MeasureOvermode co-pay,
MeasureOverNRx,
MeasureOverNQTY,
MeasureOverTRx,
MeasureOverTQTY
FROM
CalculationsTable.xlsx
(ooxml, embedded labels, table is Sheet1);

Cheers ,

Bhushan N