Project

General

Profile

Actions

Feature #220

open

Automatically segment large lookup tables upon .csv import to RuleMaker

Added by Joseph Potvin 10 months ago. Updated 9 months ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Refine
Start date:
07/26/2023
Due date:
% Done:

0%

Estimated time:

Description

Sometimes when importing a .csv file into RuleMaker's "Lookup Table" utility, the source table might be larger than the RuleMaker application can conveniently handle. This task is to design and create a simple routine that will automatically generate hierarchical forward-chained tables [table->subtables->subsubtables] when there are many columns of hierarchical data; and automatically generate sequential forward-chained tables [table1->table2->table3...] when there are many rows data. Suggestions for how to implement this can be discussed in replies to this 'task'.

RuleMaker is not running the data queries, but it does provide a general utility for converting locally stored .csv tuples of reference data into DWDS-conformant .json tuples available for universal use over the IPFS Internet. Typically one needs to first determine if most queries of a lookup table will be sequential or random. RuleMaker's Lookup Table generator needs to support both.

I have checked boxes for Don, Ted and Nhamo to 'watch' this task, as each of you might have suggestions for a simpler and/or more standard way to meet this requirement; and at least to be aware that we're planning to do this.


Files

map-of-topo-maps.JPG View map-of-topo-maps.JPG 478 KB Joseph Potvin, 08/01/2023 05:04 PM
selected-rows.png View selected-rows.png 11.3 KB Joseph Potvin, 08/01/2023 05:37 PM
selected-columns.png View selected-columns.png 17.6 KB Joseph Potvin, 08/01/2023 05:37 PM
selected-rows-and-columns.png View selected-rows-and-columns.png 17.3 KB Joseph Potvin, 08/01/2023 05:37 PM
segmented-lookup-table.png View segmented-lookup-table.png 85.1 KB Joseph Potvin, 08/01/2023 06:20 PM
Actions

Also available in: Atom PDF