Hi !
I want to select values in two different tables to join via table values but I have a compilation error.
Can you help me please ? (See picture):
I want to select idenvoi, idflux, and statut from "PAS_RAU"."T_ENVOI" and idenvoi from "PAS_RAU"."T_DECLARATION"
alt text
Hello @wallyd241 ,
There are two ways to do it:
1. Change the Column name directly like :
select e.IDFLUX, e.IDENVOI as IDENVOI1, d.IDENVOI as IDENVOI2, e.STATUT from PAS_RAU.T_ENVOI e, PAS_RAU.T_DECLARATION d
2. Use shortnames attribute: set shortnames=false
Syntax: shortnames=
Description: By default, the returned fields will be in the form .
return fields called
like | dbxquery query="your_query" connection="connection_name" shortnames=false
http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Commands
Thank you for this help:
In the Db connect hi no accepte this syntax, i add the "shortnames=false" on the search.
Thanks.
hi @wallyd241 ,
Did you get a chance to check out @vishaltaneja07011993 's answer? Did it work for you? If so, would you approve his answer so that the rest of the community knows it's correct? If it's not correct, would you update us as to the status of your problem?
Thanks!
Hello @wallyd241 ,
There are two ways to do it:
1. Change the Column name directly like :
select e.IDFLUX, e.IDENVOI as IDENVOI1, d.IDENVOI as IDENVOI2, e.STATUT from PAS_RAU.T_ENVOI e, PAS_RAU.T_DECLARATION d
2. Use shortnames attribute: set shortnames=false
Syntax: shortnames=
Description: By default, the returned fields will be in the form .
return fields called
like | dbxquery query="your_query" connection="connection_name" shortnames=false
http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Commands