Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

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
Highlighted
Employee
Employee

Re: BEx query syntax

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 

1 Reply
Highlighted
Employee
Employee

Re: BEx query syntax

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