Note:desc and KxDesc files are SAP Predictive Analytics dataset description files and will not be loaded.

Customers orders

This data set presents website purchase, and includes a reference file (customers_references.txt) describing static information on customers and a transaction file (customers_transactions.txt) with the customer purchases.

Customers references

Variable

Description

Example of Values

UserID

the customer key

Any numerical value

Country

the customer country

ITALY, FRANCE, …

Site

the site domain

net, com, .fr

IDProv

Level of study

A value between 1 and 16

OrdersCount

the number of orders posted

Any numerical value

Customers transactions

Variable

Description

Example of Values

UserID

the customer key

Any numerical value

ItemPurchased

the item purchased

A product category

Date_PutInCaddy

the order date

A date

Quantity

the ordered quantity

Any numerical value

TransactionID

the order transaction id

Any numerical value

Website navigation

This data set presents website navigation and includes a reference file (website_references.txt) including the session identifiers sessions and a transaction file (website_transactions.txt) with the list of page views associated with a session.

Session references

Variable

Description

Example of Values

SessionID

the session id

Any numerical value

Session transactions

Variable

Description

Example of Values

SessionID

the session id

Any numerical value

Page

the visited page

A page name

TransactionID

the associated transaction id

A date

IPAddress

the visitor IP address

An IP address

Time

the date/time of the visit

A date/time

Step 1: Create the table structure

Connect to the HXE tenant using the ML_USER user credentials and execute the following SQL statement to create the table structure: