Field Manipulation in SQL data source

[akpofureenughwu]

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..

[sinanozdemir]

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.

[sunny_talwar]

You can use Preceding load to make manipulations:

Preceding Load

LOAD FieldA * FieldB as FieldC,

          *;

SQL SELECT

FieldA,

FieldB

FROM Source;

[akpofureenughwu]

Thanks everyone.. I appreciate

[oknotsen]

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 .

[akpofureenughwu]

@ 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..

[sinanozdemir]

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

[akpofureenughwu]

Thanks Mehn.