topic Re: A function to add columns with names that has a prefix in Discussions

A function to add columns with names that has a prefix

DivisiveEagle45 — Mon, 22 Apr 2024 19:01:22 GMT

Hi community,

I want to write a function to add columns that have names that has a given prefix, and give values to the columns based on given conditions. This is the script that I have, but it errors out "Unresolved Column". I double checked everything and don't know where went wrong...

Much appreciated for the help!

add_extra_columns = Function({dt, prefix},
	{Default Local},
	dt << New Column("Data Usable?",
		Numeric,
		"Continuous",
		Format("Best", 12), 
 
 
		Set each value(
			If(
				!Is Missing(
					Column(dt, add_prefix_to_col_name("Image", prefix)),
					If(Column(dt, add_prefix_to_col_name("Status", prefix)) == "Failed",
						0,
						If(
							Is Missing(Column(dt, add_prefix_to_col_name("Area Ratio", prefix)))
							 & Column(dt, add_prefix_to_col_name("Shape", prefix)) != "Square",
							0,
							If(
								Column(dt, add_prefix_to_col_name("Status", prefix)) ==
								"Succeeded" | Column(
									dt,
									add_prefix_to_col_name("Status", prefix)
								) == "Warning",
								1
							)
						)
					)
				)
			)
		)
	)
);
 
 
add_prefix_to_col_name = Function({col_name, prefix}, // folder_path： the "\" at the end of the string is necessary
	{Default Local}, 
 
	If(prefix == "",
		new_name = prefix || col_name,
		new_name = prefix || " " || col_name
	);
 
	Return(new_name);
);

Re: A function to add columns with names that has a prefix

jthi — Mon, 22 Apr 2024 19:08:50 GMT

You seem to be creating single column named "Data Usable?" and no columns which have specific prefixes. Generally you would maybe want to change Column() to As Column() inside your Set Each Value but I'm not exactly sure what you are trying to do.

Re: A function to add columns with names that has a prefix

DivisiveEagle45 — Mon, 22 Apr 2024 20:34:21 GMT

Hi Jarmo,

Thanks for replying. Sorry that I was not clear with my question. The new column name is just "Data Usable?". But the part within the "Set each value" is giving me problems. I want to set the value of the new column name based on column names that has a certain prefix.

Re: A function to add columns with names that has a prefix

jthi — Mon, 22 Apr 2024 20:48:33 GMT

Try changing Column() to As Column() or Column()[]

Column(dt, add_prefix_to_col_name("Image", prefix)

AsColumn(dt, add_prefix_to_col_name("Image", prefix)

Column(dt, add_prefix_to_col_name("Image", prefix)[]

Re: A function to add columns with names that has a prefix

DivisiveEagle45 — Mon, 22 Apr 2024 21:16:57 GMT

Unfortunately, all do not work, regardless AsColumn or Column()[]

Re: A function to add columns with names that has a prefix

jthi — Tue, 23 Apr 2024 05:31:58 GMT

Then I would try to simplify your function add_extra_columns. Make it have only one if statement and after you get that working start adding more.