How do I name data table after a cell value

Question

Hello,

I have a simple script that combines relevant columns from two data sets, matching by data.

For each batch of data, the column Date contains the same value in every row.

My script includes:

Output Table( "Data 1 and 2"))

How would I append a value from the Date column in front of the string, so that the table becomes, for example, "23.09.20 Data 1 and 2".

Thank you.

HadleyMyers · Accepted Answer

Hi,

One way to achieve what you're after may be to first capture the value of the date from one of the tables in a separate variable:

dt=data table ("Name of First Table");<BR />date=Format(Column(dt,"Name of Date Column")[1],"dd.mm.yyy");

After the join, you can rename the table using the "set name" argument:

joined_table=dt<<join(...);
joined_table<<set name(date || " Date 1 and 2");

Please try that and let us know if it works for you.