topic Re: Table not found Error. in Water Cooler

Table not found Error.

solomonadjei — Thu, 13 Dec 2018 14:53:23 GMT

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

Re: Table not found Error.

m_woolf — Thu, 13 Dec 2018 15:04:12 GMT

Try adding noconcatenate before the load:

PrincessAlexandra:
noconcatenate
LOAD

Re: Table not found Error.

solomonadjei — Thu, 13 Dec 2018 15:25:10 GMT

It worked 🙂

Thanks very much, I really appreciate this!

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

Re: Table not found Error.

m_woolf — Thu, 13 Dec 2018 15:33:35 GMT

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.

Re: Table not found Error.

solomonadjei — Thu, 13 Dec 2018 15:37:44 GMT

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