topic Re: Conditional transformations in Discussions

Conditional transformations

abmayfield — Thu, 08 Jun 2023 16:36:29 GMT

I have a somewhat strange need, though I think it might actually be possible to achieve even without JSL. What I want is to transform certain columns based on a column property, specifically text. "If column has the following text: XYZ, then carry out this formula, else do nothing." I know how to do "if/then" formulas but is there a scripting syntax to only modify columns with certain properties? I have many columns, or else I'd simply do it manually!

Re: Conditional transformations

txnelson — Mon, 13 Feb 2023 14:27:29 GMT

Could you please clarify your statement

"If column has the following text: XYZ, then carry out this formula, else do nothing."

Are you looking for XYZ being found in the column name, or in the any of the data values found in the column?

Re: Conditional transformations

abmayfield — Mon, 13 Feb 2023 14:57:47 GMT

Thanks. Should have clarified. I am referring to the text in the column name rather than the actual data in the table’s cells. So: “if column name includes xyz, then do this transformation.”

Re: Conditional transformations

txnelson — Mon, 13 Feb 2023 15:32:44 GMT

Here is the general structure of what you need to do....

names default to here(1);
dt=current data table();
colNames = dt << get column names(string);

for each({Name}, colNames,
	if(contains(Name,"nox"),
		for each row(
			column(name)[row()] = ???????????;  // your formula here
		)
	);
);

Re: Conditional transformations

abmayfield — Mon, 13 Feb 2023 16:35:31 GMT

Perfect! Thanks so much. I knew this functionality must exist!