Convert a list of strings into a column names

tarkan_bih — Mon, 04 Jun 2018 23:42:08 GMT

I am trying a to run a script that uses a regex to find column names and puts them in a list to then stack. I am struggling to get the actual stack part to work and I think it has to do with the list containing strings rather then column names. Is there a way to convert a list strings into column names?

ref = open(dir||datafile);

allColNames = ref << getcolumnnames;
edgeCols = {};

Ncols = N items(allColNames);
for(i = 1, i <= Ncols, i++,
	cname = Column(allColNames[i]) << get Name;
	if(!Is Missing (regex(cname,"EDGE\d+") ),
		insert into(edgeCols,cname);
	);
);


edge stack = ref << stack(
	columns(EdgeCols),
	Source Label Column("Label");
	Source Data Column("Data");
	Output Table("Stack");
);

Re: Convert a list of strings into a column names

gzmorgan0 — Tue, 05 Jun 2018 07:49:51 GMT

Your syntax for stack is incorrect:

there are semicolons where there should be commas
it is not Source Data Column but Stacked Data Column

edge stack = ref << stack(
	columns( edgeCols),
	Source Label Column("Label"),
	Stacked Data Column("Data"),
	Output Table("Stack")
);

topic Convert a list of strings into a column names in Discussions

Convert a list of strings into a column names

Re: Convert a list of strings into a column names