Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
brunopaulo
Partner
Partner

BEx query syntax

Hello Community,

I installed the SAP Connector in order to use BEx query and it's all ok with this.

For script purposes i would like to know how can i select all fields at once without wrote all of them.

At the moment i have the following:

Teste:

Select [Table]

Dimensions (Field1,Field2,)

Measures (Field3, Field4,)
Units(Field5,Field6,)

From [Table];

 

And what i wanted is something like

Teste:

Select * 

From [Table];

Hope anyone can help me. 

Thank you

Bruno Paulo

1 Solution

Accepted Solutions
mats_olin
Employee
Employee

Hi Bruno, there is no SELECT * functionality in the BEx connector. There is an 'All Query dimensions' checkbox in the Sense select dialog that will include all dimensions but they will be listed individually in the script. 

/ Mats 

View solution in original post

1 Reply
mats_olin
Employee
Employee

Hi Bruno, there is no SELECT * functionality in the BEx connector. There is an 'All Query dimensions' checkbox in the Sense select dialog that will include all dimensions but they will be listed individually in the script. 

/ Mats