Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
laxmanqlik
Creator II
Creator II

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
Mark_Little
Luminary
Luminary

HI,

Just add it to the script

Like

Load

     Field1,

     Field2,

     Feld1 + Field2      AS Field3

From ...

Mark

laxmanqlik
Creator II
Creator II
Author

thank Mark,

but my two fields are in different databases.

laxmanqlik
Creator II
Creator II
Author

thank Mark,

but my two fields are in different databases.

Mark_Little
Luminary
Luminary

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