River Logiceode docs

Datasets

Find the data you've imported, see who can use it, share it with your organization, and organize the tables inside each dataset.

Where: Datasets

A dataset is data you've brought into eode from an Excel workbook. You import it once and it stays in Datasets, where you open it, edit it, and pick it for any model. A dataset's tables are called resources.

Find a dataset

Click Datasets in the rail, just below Models. The list works with no model open. Its header reads Datasets · and how many datasets are listed right now. Import data, at the top right, brings in a new one; see Import data.

ControlWhat it does
Search datasetsEvery word you type must appear in the dataset's name. Resource names aren't searched.
SortLast updated (the default), Newest or Name.
ShowAll, everything you can see, or Shared with my organization, the datasets shared with your whole organization. Each carries a count, which follows your search.

eode remembers your sort and your Show choice in this browser, per account. The search starts empty each visit.

Read a row

Click anywhere on the row to open the dataset. Under the name, one line of facts tells datasets apart, even copies of the same workbook:

  • Used by and the models built from it that you can see: one or two by name, more as a count, like Used by 3 models. Used by no model yet when there's none.
  • How many resources it holds, counted as sheets, like 3 sheets.
  • How many rows, like 7 rows.

A dataset made from an engine model file reads Engine model file and the file's size instead. While a file is still uploading, the row carries an Uploading chip.

On the right, Updated and how long ago, like Updated 3d ago; hover it for the exact date and time. It hides in a very narrow window.

Act on a dataset from its row

Click … on a row. The menu holds, in this order:

ItemWhat it does
RenameTurns the name into a box. Enter or clicking away saves, Esc cancels. An empty or unchanged name saves nothing.
DuplicateAsks Duplicate name, with the name "{name} copy" filled in, and makes a copy you own on Duplicate. The copy opens when it's made. An empty name cancels. Not on an engine model file.
Share with my organization / Stop sharing with my organizationSee below. Only for Org Admins and Promoters.
Who can open itSee below. Only for Org Admins.
DeleteSee below.

If an action fails, a dialog says Could not and the action, for example Could not duplicate Harbor Point Bakery — sales and costs., followed by eode's reason.

See who can use a dataset

What each role can do:

You areYou can
Anyone who can see the datasetOpen it, preview it, duplicate it, pick it for a model.
Owner, contributor, or Org AdminAlso rename it, edit its resources and save.
Owner or Org AdminAlso delete it.

The people in these roles are the dataset's roster. You see a dataset when its roster names you, or when it's shared with your organization. An Org Admin sees every dataset in the organization. Changes to a shared dataset you aren't on the roster of are refused when you save.

See the roster

Organization admin

Click … on a row, then Who can open it. Who can open name lists the people in each role: OWNERS, CONTRIBUTORS, VIEWERS, PROMOTERS and AI AGENTS, each with a count. An empty role reads none. A shared dataset's list ends with Shared with my organization.

The list is read-only: "The people who may open or change it, by what they may do. It cannot be changed here." ✕ or Esc closes it.

Share a dataset with your organization

Org Admin or Promoter

Click … on a dataset that isn't shared yet, then Share with my organization. eode asks Share name with your organization?: "Every member of your organization will be able to see and preview it. Only its roster can edit it." Click Share. The dataset is now listed under Show → Shared with my organization.

On a shared dataset the item reads Stop sharing with my organization. eode asks Stop sharing name with your organization?: "Only the people on its roster keep access." Click Stop sharing.

The item shows only to Org Admins and Promoters. Sharing also needs you to be the dataset's owner, a promoter on it, or an Org Admin. Roles are explained in Roles and personas.

Delete a dataset

Click … on a row, then Delete. eode asks Delete name?: "Its imported sheets and rows are removed with it. This cannot be undone." For an engine model file it says "Its file is removed with it." instead.

When models were built from the dataset, the dialog names them first, one or two by name or more as a count, and says that a model that loads its data from it will need it chosen again. See Load your data.

Open a dataset

Click a dataset's row. The page shows the name, the resource count, and two columns: the Resources list on the left and the open resource's grid on the right.

  • The first resource opens by default. The one you last picked stays open after a save or a reload.
  • Each resource in the list shows its row count. Click one to open it.
  • Editing the grid is covered in Edit a dataset.

Build a model from this file, at the top of the Resources list, starts a new model from this dataset. New Model opens and sends My datasets: name. for you with the dataset attached, and RIA reads it from there.

Switching to another resource drops unsaved edits in the grid without asking. Save first.

When a resource was cut at the row limit during import, a line above its grid reads "Truncated from N rows at the source.", with N the row count in the workbook. See Import limits.

Organize the resources

Above the resources, the Resources list has four controls.

ControlWhat it does
Filter resourcesNarrows the list by name as you type. Esc clears it, a second Esc leaves the box, ↓ moves into the list. The open resource stays open even when it's filtered out.
Sort resourcesName A–Z (the default) or Name Z–A. Your pick is remembered in this browser.
+ (Add resource)Empty table or Import data.
⋮ (Dataset actions)Lay another dataset over this one…. See Combine two datasets.

Hover a resource to show its pencil (Rename resource) and trash (Delete resource). Deleting asks first: "Its rows are removed with it. This cannot be undone."

Add an empty table

  1. Click +, then Empty table.
  2. Type a name in New resource ("It starts empty, with a header row you can rename in the grid.") and click Next.
  3. Enter how many columns it should have (3 by default) and click Create.

The table opens with columns named Column 1, Column 2, and so on, and one blank row. Rename the columns in the grid.

Add tables from a workbook

Click +, then Import data. The Import data window opens without a name field, and the tables you pick are added to this dataset.

Combine two datasets

Lay one dataset over another to get a third that holds both. Neither of the two changes.

  1. Open the dataset to start from, click ⋮ at the top of the Resources list, then Lay another dataset over this one…. "Where a row is in both, the values of the dataset you pick are used, and its other rows are added. Tables read from an engine model file are taken whole, so they match the file. The result is a new dataset."
  2. Pick the other one in Dataset to lay over it. Engine model files aren't listed.
  3. Name of the combined dataset starts as <this one> + <the other>. Change it if you like.
  4. Click Combine.

The dialog then says what changed and counts it: Rows that took new values, Rows with blanks filled, Rows added, Rows unchanged and Cells needing a decision (and Rows removed, when reported). Open the combined dataset opens it.

You only need to be able to see both datasets; the new one is yours. If it fails, the dialog reads Could not combine them: and the reason. With no other dataset to pick, it says "There is no other dataset to lay over this one."

When a list is empty or doesn't load

You seeWhat it means
Loading your datasetsThe list is still loading. If it takes long, it reads This is taking longer than expected with Try again.
No datasets yet.You have no datasets and none are shared with you. Import data starts one.
Nothing matches your search.The search found nothing. Clear search empties it and sets Show back to All.
Nothing here matches what you chose to show.Nothing is shared with your organization yet, for example. Show every dataset sets Show back to All.
Your datasets could not be loaded.The list didn't load. "Check your connection, then try again." Click Try again. The count beside Datasets shows a dash.
This dataset has no resources.The import produced no data. New resource adds an empty table; Datasets goes back to the list. A dataset with no data can't build a model yet, and the page says so.
Could not load this dataset: reasonTry again.
Could not create the resource:, Could not rename the resource:, Could not delete the resource:The action was refused or failed; the reason follows.

Limits

  • Search matches dataset names only.
  • An empty table starts with at most 50 columns. A larger number is cut to 50. Add more in the grid.
  • Import data: bring a workbook in as a new dataset, or add its tables to one
  • Edit a dataset: change rows, columns and values in a resource
  • Load your data: pick a dataset for a model and bind it
  • Data connections: which sources the Import data window can read
  • Models: the same list header and row menu for models

On this page