topic Re: Data has not been loaded. Please correct the error and try loading again. in Connectivity & Data Prep

Data has not been loaded. Please correct the error and try loading again.

ga1996 — Fri, 10 Dec 2021 21:09:00 GMT

I am trying to load this script:

LOAD ProductID, UnitCost FROM [lib://Case_study_3:DataFiles/abc_4.0.xlsx] (ooxml, embedded labels, table is products); // ----- UnitCost Map ----- // UnitCost_Map: MAPPING LOAD ProductID, UnitCost; SQL SELECT ProductID, UnitCost FROM products;

but I get this error:

Started loading data

products Lines fetched: 78

The following error occurred:

There is no open data connection.

The error occurred here:

SQL SELECT

ProductID,

UnitCost

FROM products

Data has not been loaded. Please correct the error and try loading again.

What am I doing wrong here? Any help would be highly appreciated.

Re: Data has not been loaded. Please correct the error and try loading again.

AshutoshBhumkar — Sun, 14 Nov 2021 05:29:26 GMT

Hello,

Try like below, taking resident after SQL table loads..

// ----- UnitCost Map ----- //
UnitCost_Map:
LOAD
ProductID,
UnitCost
SQL SELECT
ProductID,
UnitCost
FROM products;

UnitCostMapping:
MAPPING LOAD
ProductID,
UnitCost
Resident UnitCost_Map;
Drop Table UnitCost_Map;

Thanks,

Ashutosh

Re: Data has not been loaded. Please correct the error and try loading again.

vinieme12 — Mon, 15 Nov 2021 07:27:14 GMT

your error message is right here

The following error occurred:

There is no open data connection.

make sure you add the connection to the database table into the load script before running any SQL commands

you must connect to your DB connection as

"LIB CONNECT TO <your connection name>" before running sql statements