Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

laxmanqlik
Contributor

How to add a column when fetching data from database

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.

4 Replies
mark6505
Valued Contributor III

Re: How to add a column when fetching data from database

HI,

Just add it to the script

Like

Load

     Field1,

     Field2,

     Feld1 + Field2      AS Field3

From ...

Mark

laxmanqlik
Contributor

Re: How to add a column when fetching data from database

thank Mark,

but my two fields are in different databases.

laxmanqlik
Contributor

Re: How to add a column when fetching data from database

thank Mark,

but my two fields are in different databases.

mark6505
Valued Contributor III

Re: How to add a column when fetching data from database

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

Community Browser