Join

Definition: Join function can allow you to join between multiple tables. While making the join you can specify the tables and columns on which the joining happens as well as the join type as well. With the join operation happening successfully it will create another table.

The syntax can be something like Join table1/file1 with table2/file2 using column1 (which belongs to tabl21/file1) and column2 (which belongs to table2/file2)

Example: In the below example we are doing join operation between two files (can be done for tables also etc)

Join enrollments and students using public_id and student_id

Where in two files i.e. Enrollments and Students are getting inner joined.Public_id is a column belonging to enrollments table and student_id is belonging to students table.

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