Union

Definition: Union function can allow you to add the data of one file/table to another file or table at the bottom i.e. records will get appended. If the columns of both files are matching then it will get added in those respective columns, if not it will create additional columns.

Also when the union command is triggered it creates a unique file in which both the files union happens.

Example: In the below example we are merging two files (can be done for tables also etc)

Union Enrollments and Students

Where in two files are getting merged by the names of Enrollments and Students and creating a new file

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 support@askondata.com for any questions or help