Concatenate values in a column

tdiehl — Fri, 09 Jun 2023 23:24:18 GMT

Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below.

ROW COL CELL

5 1 5_1

3 2 3_2

12 -1 12_-1

best shot at code so far:

column("ROW") << Data type(Character);
column("COL") << Data type(Character);

//a = {column("ROW"), column("COL")};  
ConExpr = concat items({column("ROW"), column("COL")} , "_"); 

//Add "CELL" column = concat col(ROW) "_" col(COL)
dt << new column("CELL",Character, "Nominal", Format("Best", 12), formula(eval(Expr(ConExpr))));

my results:

CELL

Any help in understanding why my code evaluates to that and the correct implementation would be greatly appreciated.

Re: Concatenate values in a column

txnelson — Thu, 31 Aug 2017 19:04:29 GMT

Here is all you need to do:

dt << new column("CELL", character,
     formula(:ROW || "_" || :COL));

topic Re: Concatenate values in a column in Discussions

Concatenate values in a column

Re: Concatenate values in a column