topic Re: Create "Source Table" Column in Table that references Data Table Name in Discussions

Create "Source Table" Column in Table that references Data Table Name

kmprosperi — Mon, 01 Jul 2024 19:14:01 GMT

Hi!

I'd like to create a column called "Source Table" that auto populates with the name of data table that is being worked on.
This is done when concatenating multiple file names; but I'd like to do it at the start of all my workflows as a matter of practice (without having to manually add it).

Is this possible?
Thanks!
Katie

Re: Create "Source Table" Column in Table that references Data Table Name

jthi — Mon, 01 Jul 2024 19:23:40 GMT

You could at least add a small script to perform that column creation. Here is one option for that

Local({dt, newcol},
	dt = Current Data Table();
	If(!Contains(dt << Get Column Names("String"), "Source"),
		newcol = dt << New Column("Source", Character, Nominal, Formula(
			dt << get name;
		));
		dt << Run Formulas;
		newcol << Delete Formula;
	);
);

(I added If statement to avoid re-creation of the column if Source column already exists, but you can drop it if it isn't needed)

Re: Create "Source Table" Column in Table that references Data Table Name

jthi — Mon, 01 Jul 2024 19:35:22 GMT

Also in this case you can use Set Each Value, it makes the script a bit simpler

Local({dt, newcol},
	dt = Current Data Table();
	If(!Contains(dt << Get Column Names("String"), "Source"),
		newcol = dt << New Column("Source", Character, Nominal, Set Each Value(
			dt << get name;
		));
	);
);

Edit:

A bit cleaned version below, as this doesn't need Local() (I added it for newcol variable to make it easier to remove the formula from created column for the formula version)

If(!Contains(Current Data Table() << Get Column Names("String"), "Source"),
	Current Data Table() << New Column("Source", Character, Nominal, Set Each Value(
		Current Data Table() << get name;
	));
);

Re: Create "Source Table" Column in Table that references Data Table Name

txnelson — Mon, 01 Jul 2024 19:29:47 GMT

Here is a Work Flow step that can be added that adds the Source Table column to the current data table

Re: Create "Source Table" Column in Table that references Data Table Name

kmprosperi — Mon, 01 Jul 2024 19:33:06 GMT

Thank you!!!
This solves my problem beautifully!

Re: Create "Source Table" Column in Table that references Data Table Name

kmprosperi — Mon, 01 Jul 2024 19:34:01 GMT

Thank you!! I am stepping away from standalone scripts & into the world of workflows! This will be helpful!