State
Console
State
!
Current
0
Total
0
Time
00:00
Auto Query with Excel
1.Select Type
Copy and paste excel table or load excel file. Click to Select
2.Copy and Paste
Paste excel table datas and click create table button
2.Load File
Load excel file and click create table
3.Select All or Specific
Select all or select pivot object from excel table
4. Specific Selection
Firstly click 'Select Pivot' and select an object from the table. Then select a row 'Select Row'or column 'Select Column' . Then if you want to delete the objects from selection , click 'Delete Object' and select an object from the table. If you are ready, click 'Continue'
5. Delete Duplicate
If the table has identical contents, do you want to delete their duplicates?
6. Prefix Block
Do you want to add prefix block for query? If you want to add a prefix, you can write it in this box. If you don't want it, leave it blank.
7. Suffix Block
Do you want to add suffix block for query?If you want to add a suffix, you can write it in this box. If you don't want it, leave it blank.
8. Ready to Query
Example Query 1:
Example Query 2:
Like the example query,queries will be made. Click the 'Start' button to start.