Forum Posts Feed
Software that supports custom attributes and can generate all combinations of them?
< Next Topic | Back to topic list | Previous Topic >
Posted by Andy Brice
Feb 14, 2023 at 11:30 AM
Generating all possible combinations of the members of 2 different sets is more commonly known as a “cross join” or “cartesian product”. The results can get very big very quickly if you have non-trivials sets!
I’m not sure what sort of format you want this in, but Easy Data Transform can do this using the ‘Cross’ transform and then output it in various formats (CSV, YAML, Excel etc).
https://www.easydatatransform.com/help/latest/windows/html/cross.html
Posted by Amontillado
Feb 14, 2023 at 12:44 PM
Easy Data Transform is one of those tools that keeps finding ways to save time. Andy’s latest video presents ideas for how to analyze server log files with Easy Data Transform, something that had not occurred to me.
Merging and mining data from multiple sources is a snap. I got my money’s worth on my first use of the product.
Posted by Alexander Deliyannis
Feb 15, 2023 at 08:20 PM
Hear! Hear!
Amontillado wrote:
>Easy Data Transform is one of those tools that keeps finding ways to
>save time.
Posted by 22111
Feb 27, 2023 at 05:34 PM
Since this thread has degenerated into an ad for some data transform software (which has certainly its place in the toolbox of users who don’t know about regex), does anyone remember the original, the thread starter’s, question?
To which is answer obviously is, get some free SQLite db frontend, and then have a look into sqlitetutorial.net (and similar web sites) - since indeed, the usual CSV viewers (some of them free, again) ain’t powerful enough, and MS Excel… well… why searching for complications where there are none inherent, right?
Posted by Amontillado
Mar 1, 2023 at 12:50 PM
C’mon, man, please leave room for others having experience you would benefit from.
Sqlite is a database with limitations. It’s great within those limits. Easy Data Transform is an analysis tool with powers and abilities far beyond mere regex (which, among many other things, EDT supports).
Would you use sqlite for, say, desktop publishing? No, of course not. It’s not a graphics and layout tool, it’s a database. Would you use EDT as a relational database? You could, it does joins and lookups and column operations - but it’s not a good choice for a web site backend.
Easy Data Transform is to sqlite as Corvettes are to crowbars. There are things you can do with crowbars that you can’t do with Corvettes. Crowbars are fine tools. Corvettes are fine sports cars. Neither is better than the other.
It is, however, more impressive to arrive at the office in a Corvette instead of dragging a crowbar. Easy Data Transform makes a good impression, too.
22111 wrote:
Since this thread has degenerated into an ad for some data transform
>software (which has certainly its place in the toolbox of users who
>don’t know about regex), does anyone remember the original, the thread
>starter’s, question?
>
>To which is answer obviously is, get some free SQLite db frontend, and
>then have a look into sqlitetutorial.net (and similar web sites) - since
>indeed, the usual CSV viewers (some of them free, again) ain’t powerful
>enough, and MS Excel… well… why searching for complications where
>there are none inherent, right?