Need Help

[paulwalker]

Hi Community,

I have one requirement..

I have 2 tables

Table1:

ID, Value

100, 2500

200, 3000

300, 3500

Table2:

ID,  Value

100, 1000

200,  5000

300,  2500,

400,  4500

500,  2000

Here, ID values 100, 200, 300 are same but values are different..

I want to replace the Values in Table2.

My Output should be

Output:

ID, Value

100, 2500

200,  3000

300,  3500,

400,  4500

500,  2000

Thanks in Advance...

[puttemans]

Indeed, mapping selects only one of them, not both. So if you have in your table you're mapping a duplicate value, the mapping process is not optimal.

[maxgro]

with mapping if you have n records in Table2

you get the same number of record in output table

the requirement was to replace values in Table2, not to add records in Table2, so I think mapping works

[qlikviewwizard]

Hi

Please use the below script:

Table1:

LOAD * INLINE [

ID, Value

100, 2500

200, 3000

300, 3500

];

Table2:

LOAD * INLINE [

ID,  Value

100, 1000

200,  5000

300,  2500,

400,  4500

500,  2000]

Where Not Exists(ID)

[paulwalker]

Thanks For reply EveryOne..

Table1:

ID	Customer
100	Andy
101	Sandy
102	Luria
103	Paul
104	Ruzia

Table2:    

ID	Customer Name	Value
100	Andy	20000
	Andy	2300
111	Andy	3400
200	Ruzia	1200
101	Sandy	2300
103	Paul	2300
123	Paul	2500
105	Kanna	12000

I have 2 tables, I want map ID to ID and Customer to Customer.

Suppose i have 2 List boxes 1. Customer and Customer Name

and TextBox=  Sum(Value)

If i am click Customer and Customer Name

It should be  Andy= 22300, because here compare  ID to ID and Customer to Customer.

Suppose Kanna= 12000  and paul=2300

Hope You Understand.......

[paulwalker]

This is only for example,

but my source data many of Null (ID and Customer both)

[Ralf-Narfeldt]

I fail to see the use of Table 1, because the information is already in Table2.

Why do you need to link them?

Are Andy with  ID100 the same as Andy with ID 111?

[paulwalker]

Yeah Ralf,

My data like that only..

I have most of the null values, even ID's and Customer Also....

I want to  get values from Table2, If i don't have any Common ID's also i want to get the data..