topic Re: Advanced DataSources Merge in QlikView

Advanced DataSources Merge

Tue, 01 Apr 2014 12:08:03 GMT

Hi All,

I have a little difficult with import and merging data from two different datasources.

In the 1th datasource I have a table like this

ID	Key	Value
1	a	1
2	b	1
3	c	3
4	d	4
5	e	4

In a 2nd datasource I have another table like this

ID	Value
2	2
5	5

Finally, I want to update the value column in the first table using the corresponding int the 2nd one like this

ID	Key	Value
1	a	1
2	b	2
3	c	3
4	d	4
5	e	5

I wrote this script but it does not work properly.

Fixed:

LOAD

, Value

From

Qvd\Fixed.qvd

(qvd);

Concatenate (Fixed)

LOAD

From

Qvd\Source.qvd

(qvd)

Where Not Exists(ID);

Can someone please help me?

Thanks a lot.

Re: Advanced DataSources Merge

alexandros17 — Tue, 01 Apr 2014 12:14:30 GMT

Ecco qui'

Re: Advanced DataSources Merge

sujeetsingh — Tue, 01 Apr 2014 12:20:47 GMT

See this Sample script:

Tab1:

LOAD * INLINE [

ID, Key, Value

1, a, 1

2, b, 1

3, c, 3

4, d, 4

5, e, 4

];

Tab2:

LOAD * INLINE [

ID, Value

2,2

5,5

];

Data:

LOAD

ID, Key as KEY, Value

Resident Tab1;

DROP Table Tab1;

Join(Data)

LOAD

ID, Value as Val2

Resident Tab2;

DROP Table Tab2;

FinalData:

LOAD

ID,KEY

,if(IsNull(Val2)=0,Val2,Value) as Value

Resident Data;

DROP Table Data;

Re: Advanced DataSources Merge

Wed, 02 Apr 2014 07:19:11 GMT

Thanks a lot for all responses.

It was what I needed.