Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Aliasing Select Statement

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.

1 Reply
Not applicable

Re: Aliasing Select Statement

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.

Community Browser