I would like to combine 2 numeric column data with a delimiter.
First I used cancat function with a third concat character but it seems the columns to be character. I used the char function but the result is obvious if you look at Column "Column".
Column Utilities "Combine Colums" make the thing perfectly but it does not implement the formula inside the column properties so no automation.
I have this script from the help menu but i can not adapt it as a formula and outside jsl option does not help me becuse of full automation.
Really appreciate any help
delimiter( "," ),
:Brush After Waking Up,
:Brush After Meal,
:Brush Before Sleep,
:Brush Another Time
Selected Columns are Indicator Columns( 1 ),
Column Name( "When to Brush" )
Click on Cols > New Column
Name the column When to Brush
Click Column Properties > Formula
Double-click the red box that says "no formula"
Paste the following code into the code window:
char(:Brush After Waking Up) || "," ||
char(:Brush After Meal) || "," ||
char(:Brush Before Sleep) || "," ||
char(:Brush Another Time)
Thank you PMRoz,
I am fine with it but I can't do my version where the data is numeric (date/time):
Here is the result when I
Char(:PUBLISH DATE.) || "," || Char(:REVIEW NUMBER)