Have you tried it? Recode platform will provide you with a script, such as
ocal({dt, col1},
dt = Data Table("Untitled");
dt << Begin Data Update;
col1 = dt << New Column(dt:Column 1);
col1 << Set Name("Column 1 2");
dt << Move Selected Columns({col1}, after(dt:Column 1));
For Each Row(
dt,
col1[] = Map Value(
dt:Column 1,
{"A10", "A1", "A2", "A1", "A3", "A1"},
Unmatched(dt:Column 1)
)
);
dt << End Data Update;
);
You can then modify that as needed and maybe use something like Workflow builder to make it work with different tables. Or you can script it (Get Data Table List() and For Each are good starting points for this).
-Jarmo