topic Re: Recording and recovering metadata in a table in Discussions

Recording and recovering metadata in a table

FN — Fri, 09 Jun 2023 22:09:59 GMT

I have a stacked data table with three columns that contain strings and another numeric.

A: unique identifier

B: text

C: text

As, Bs, Cs, Values

-----

A1, B1, C1, value11

A1, B1, C1, value12

A1, B1, C1, value13

A2, B2, C2, value21

A2, B2, C2, value22

A2, B2, C2, value23

Right now, I am creating a concatenated column name with the form "A (B) [C]" which I split to have the final table like so:

A1 (B1) [C1], A2 (B2) [C2],

Value 11, Value 21

Value 12, Value 22

Value 13, Value 23

I want to create a new column property that saves the As in this final table.

Do I need a loop with two lists to insert this property column by column?

Re: Recording and recovering metadata in a table

txnelson — Tue, 30 Mar 2021 15:40:23 GMT

Can you provide an example of what the contents of the new column property would look like?

Re: Recording and recovering metadata in a table

FN — Tue, 30 Mar 2021 16:47:49 GMT

Sure.

Column: A1 (B1) [C1]
A_property: A1

Column: A2 (B2) [C2]
A_property: A2

Re: Recording and recovering metadata in a table

jthi — Tue, 30 Mar 2021 16:56:13 GMT

If I understand correctly what you want - You have the property value already in the column name so you can could get it from there:

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(3),
	Compress File When Saved(1),
	New Column("A1 (B1) [C1]",
		Character,
		"Nominal",
		Set Values({"Value 11", "Value 12", "Value 13"})
	),
	New Column("A2 (B2) [C2]",
		Character,
		"Nominal",
		Set Values({"Value 21", "Value 22", "Value 23"})
	)
);

colNames = dt << Get Column Names("String");

For(i = 1, i <= N Items(colNames), i++,
	aVal = Word(1, colNAmes[i]);
	Column(dt, colNames[i]) << Set Property("A_property", aVal);
);

Re: Recording and recovering metadata in a table

FN — Thu, 01 Apr 2021 15:19:14 GMT

Sometimes As can have the pattern "abc (cde)" so better to use a mapping from the first table instead of Word().

is there a JSL dictionary we can use so the key is the column name and the value is the new property to save?
{"A1 (B1) [C1]": "A1",
"A2 (B2) [C2]": "A2"}

Re: Recording and recovering metadata in a table

jthi — Thu, 01 Apr 2021 15:36:36 GMT

Check out Associative Arrays