topic Re: How to add a column when fetching data from database in Management & Governance

How to add a column when fetching data from database

laxmanqlik — Mon, 22 Aug 2016 08:17:42 GMT

Hi all,

i am creating an app by fetching the data from two sql databses,now i have a requirement to add another calculated column,

let me know how to achieve it.

thanks in advance.

Mark_Little — Mon, 22 Aug 2016 08:38:27 GMT

HI,

Just add it to the script

Load

Field1,

Field2,

Feld1 + Field2 AS Field3

From ...

Mark

laxmanqlik — Mon, 22 Aug 2016 08:53:03 GMT

thank Mark,

but my two fields are in different databases.

laxmanqlik — Mon, 22 Aug 2016 08:53:12 GMT

thank Mark,

but my two fields are in different databases.

Mark_Little — Mon, 22 Aug 2016 09:08:47 GMT

Hi,

First of all then you are going to have to either join the two tables or map the field across.

What is the link between the two table containing your values?

Mark