Definition: Using concat operation, we can merge two columns into a single column. While merging some separator like space, -, _ etc can also be used if required.

Example: Below we are merging 2 columns into a single column using a below kind of command.

Concatfirstname and lastname using space as delimiter into Full_Name

wherein we are merging 2 columns i.e. firstname and lastname into Full_Name and using space as delimiter.


Note 1

: If you have entered some command on Ask On Data and it is asking for variables/input for that command but you want to abort that operation, then simply type "Abort".

Note 2

We will keep on retraining Ask On Data ML algorithm, hence its accuracy will keep on increasing and it will be capable of understanding more syntaxes in simple language.

Reach out on for any questions or help