Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aliasing Select Statement

Hi friends,

I have connected to QvSAPDSOConnector. I am trying to pull an infoObject from a particular DSO and rename it into a business specific format. I am trying to alias the fields in the select statement. But an error is thrown

Type: 'E', Message: 'InfoObject AS in the list of available InfoObjects does not exist in DS'

The code  I am using is

[ZCR_OCOM]:

Load *;

SQL Select

0CRM_ACGUID AS ABC

from ZCR_OCOM;

Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;

Drop table [ZCR_OCOM];

please help me with this.

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

This issue is solved.

I tried to load with alias name and then select. It is working fine now.

[ZCR_OCOM]:

Load [0CRM_ACGUID] AS ABC ;

SQL Select

0CRM_ACGUID

from ZCR_OCOM;

Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;

Drop table [ZCR_OCOM];

Thanks every one.

View solution in original post

1 Reply
Not applicable
Author

Hi All,

This issue is solved.

I tried to load with alias name and then select. It is working fine now.

[ZCR_OCOM]:

Load [0CRM_ACGUID] AS ABC ;

SQL Select

0CRM_ACGUID

from ZCR_OCOM;

Store * from [ZCR_OCOM] into ZCR_OCOM.QVD;

Drop table [ZCR_OCOM];

Thanks every one.

View solution in original post