Split

Definition: We can use Split to split a single column into multiple columns based on certain factors like presence of " / " , ‘ ‘ , " - " etc.

Definition:

1. Here we are splitting the dob based on " / " making in to three columns as year , month and date

In the image you can see that the dob column is divided into three other columns.

You can even type a single statement also like Split dob using / into date,month,year.

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 AskOnData ML algorithm, hence its accuracy will keep on increasing and it will be capable of understanding more syntaxes in simple language

Reach out on support@askondata.com for any questions or help