Aliasing Select Statement

Mon, 13 Oct 2014 05:37:17 GMT

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.

Re: Aliasing Select Statement

Tue, 14 Oct 2014 06:31:55 GMT

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.

topic Aliasing Select Statement in QlikView

Aliasing Select Statement

Re: Aliasing Select Statement