Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.