topic Re: Field Manipulation in SQL data source in QlikView

Field Manipulation in SQL data source

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Good evening everyone, Happy new month first of all. I need your help. I need to manipulate some fields from a file I pulled from my sql database via OLEDE connector. Please see the attached files for clarity..

In the picture 3 (shows the sql connection)

in the picture 4 (shows list of fields I need to manipulate).... I need to divide, multiply and add some of this fields to produce other fields for my app.

How can I do this? Thanks in advance..

Re: Field Manipulation in SQL data source

sinanozdemir — Wed, 01 Jun 2016 17:45:05 GMT

Hi,

Right above the SQL statement, you can enter another line starting with LOAD and then pull the dimensions for editing:

OLEDB CONNECT TO .......
LOAD
     Dimension1,
     Dimension2,
     etc
SQL SELECT * FROM Your_datasource

Hope this helps.

Re: Field Manipulation in SQL data source

sunny_talwar — Wed, 01 Jun 2016 17:45:23 GMT

You can use Preceding load to make manipulations:

Preceding Load

LOAD FieldA * FieldB as FieldC,

SQL SELECT

FieldA,

FieldB

FROM Source;

Re: Field Manipulation in SQL data source

akpofureenughwu — Thu, 02 Jun 2016 13:02:19 GMT

Thanks everyone.. I appreciate

Re: Field Manipulation in SQL data source

oknotsen — Thu, 02 Jun 2016 13:08:05 GMT

If your question is now answered, please flag the Correct Answer.

If not, please make clear what part of this topic you still need help with .

Re: Field Manipulation in SQL data source

akpofureenughwu — Thu, 02 Jun 2016 13:53:33 GMT

@ Sunny.. For clarity sake

LOAD FieldA * FieldB as FieldC,

SQL SELECT

FieldA,

FieldB

FROM Source;

Where should I start this preceding load statement from..

See attached file. Thanks..

Re: Field Manipulation in SQL data source

sinanozdemir — Thu, 02 Jun 2016 20:52:35 GMT

You put just above the "SQL SELECT" line. In other words, between "OLE DB CONNECT" and "SQL SELECT" lines. In my post, I indicated this.

Thanks

Re: Field Manipulation in SQL data source

akpofureenughwu — Fri, 03 Jun 2016 10:25:28 GMT

Thanks Mehn.