Table not found Error.

[solomonadjei]

Hello all,

Could someone pease tell me what am I doing wrong in the below script.

I keep getting error message:

"Table not found error

Table 'PrincessAlexandra' not found

STORE PrincessAlexandra into [..\..\QVD_Data\EOE Savings\PrincessAlexandra.qvd] "

 but the same format of script has loaded and saved the first table successfully.

PrincessAlexandra:
LOAD

    [Trust Code],
     Region,
     [Trust Name],
     Code,
     Description,
     Supplier,
     [Trust Qty],
     Money([Your price]),
     Money([Min NHS price]),
     Money([Median NHS price]),
     Money([Max NHS price]),
     Money(Spend),
     Money([Trust variance to NHS Median]),
     Money([Trust variance to NHS Min]),
     [Date (Min Price)]
FROM
[..\..\DAT_FileData\Top Saving\The Princess Alexandra Hospital NHS Trust.xlsx]
(ooxml, embedded labels, table is Sheet1);
STORE PrincessAlexandra into [..\..\QVD_Data\EOE Savings\PrincessAlexandra.qvd];


//*************TABLE TWO(Compare MPC across trusts)***************************

PrincessAlexandra1:
LOAD [Trust Code],
     Region,
     [Trust Name],
     MPC,
     Supplier,
     [Product Description],
     [eClass 3],
     Trust,
     Money([The Princess Alexandra Hospital NHS Trust  (RQW)])        as    [Product Transaction]
FROM
[..\..\DAT_FileData\Top Saving\The Princess Alexandra Hospital NHS Trust  compare.xlsx]
(ooxml, embedded labels, table is Sheet1);
STORE PrincessAlexandra1 into [..\..\QVD_Data\EOE Savings\PrincessAlexandra1.qvd];

Many Thanks

[m_woolf · Accepted solution]

Try adding noconcatenate before the load:

PrincessAlexandra:
noconcatenate
LOAD

[solomonadjei]

It worked 🙂

Thanks very much, I really appreciate this!

Could you please educate me why it was not working with the NoConcatenate ?

[m_woolf]

You didn't show your script before the load, so I was guessing based on experience.

When I see a table load that looks OK, but the table doesn't exist after the load; it is usually because it got concatenated to a table that was loaded previously in the script.

[solomonadjei]

Yes that was correct and thanks for your time. (Y)