Add the values

ravindraa — Wed, 18 Jun 2014 05:09:14 GMT

Hi, all we have one requirement, here we have 2 databases in that 1 database have Business field but one database doesn't have Business field i mean particular database which is not maintain the Business field have 3 tables, each table maintain 3 types of Business ,

i mean 1 table maintain permanent customer(code :: PRC),

2 table maintain only10 years customer(code::HRC),

3 table maintains only 5 years customer(code::SRC)

once i load these 3 table i got all values but i need to maintain these codes along with those value under Business field

EX;

tables1

customer contract status

Nag 101 Active

gopal 102 cancelled

krishna 104 active

like this my DB data existed but i need to maintain DATA like below

customer contract status Business

Nag 101 Active PRC

gopal 102 cancelled HRC

krishna 104 active SRC

if any one know please give me suggestion .

Re: Add the values

sushil353 — Wed, 18 Jun 2014 05:14:00 GMT

Hi,

While loading the data from database create a field "Business" for every table..

Table1:

Load 'PRC' as Business,

From source;

Table2:

Load 'HRC' as Business,

From source.

Table3:

Load 'SRC' as Business,

From Source;

HTH

Sushil

Re: Add the values

ravindraa — Wed, 18 Jun 2014 05:25:46 GMT

Hi Sushil Kumar,

Thanks for you suggestion for my requirement it is working.

topic Re: Add the values in QlikView

Add the values

Re: Add the values

Re: Add the values