Forum Discussion

ShrikantKhanna's avatar
ShrikantKhanna
Icon for Helper II rankHelper II
9 years ago
Solved

How to edit an existing direct query?

Hi,

 

I need help with editing an existing direct query that I have via ODBC. I have to call in another data column using the same query. 

I have some calculations running using the existing query so I cannot afford to delete and start over again.

Is there a way?

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    If you entered in the query explicitly in the "Advanced Options" when importing the data, you can get right back to that dialog box.

     

    Click "Edit Queries":

     

     

     

    Go to the query you want to modify, and hit the settings cog near "Source":

     

     

     

     

    From here, you can write in whatever you'd like.

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    If you entered in the query explicitly in the "Advanced Options" when importing the data, you can get right back to that dialog box.

     

    Click "Edit Queries":

     

     

     

    Go to the query you want to modify, and hit the settings cog near "Source":

     

     

     

     

    From here, you can write in whatever you'd like.