Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
hello
Erase the ' , ' before FROM
regards!
also you are missing a ' ; ' at the end of the load statement
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)
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);
Remove ',' From both load statement.
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