Replace the content of an column

[qlikconsultant]

Hi, I have the following problem.

A planing time table:

Planed Time	Test-Serie	Atribute A	Atribute B	Atribute C	Atribute D
20.01.2013 08:16:00	A	Number	Text	Number	Text
20.01.2013 08:19:00	A	...	...	...	...
20.01.2013 09:14:00	B	...	...	...	...
20.01.2013 09:33:00	C	...	...	...	...
20.01.2013 11:58:00	A	...	...	...	...

and an actual time table:

Actual Time	Test-Serie
20.01.2013  08:21:00	A
20.01.2013  08:27:00	A
20.01.2013  09:15:00	B
20.01.2013  09:25:00	C
20.01.2013  11:59:00	A

Betwean the planed time and the actual time are only a few minutes.

My goal is to replace the time in the planing table with the actual time. Any idea how I can accomplish that?ctual Time

[alexandros17]

What is the substitution rule?

[qlikconsultant]

If you sort both tables by time. The sequence in both tables is the same.

[#4]

Hi Markus, try with:

tmpPlanedTime:
LOAD *, RowNo() & '|' & [Test-Serie] as ID_row;
LOAD [Planed Time], 
     [Test-Serie], 
     [Atribute A], 
     [Atribute B], 
     [Atribute C], 
     [Atribute D]
FROM
[http://community.qlik.com/thread/71187]
(html, codepage is 1252, embedded labels, table is @1);

PlanedTime:
LOAD *, '' as tmp1
RESIDENT tmpPlanedTime
ORDER BY ID_row;
drop table tmpPlanedTime;


tmpActual_Time:
LOAD *, RowNo() & '|' & [Test-Serie] as ID_row;
LOAD [Actual Time], 
     [Test-Serie]
FROM
[http://community.qlik.com/thread/71187]
(html, codepage is 1252, embedded labels, table is @2);

Actual_Time:
LOAD *, '' as tmp2
RESIDENT tmpActual_Time
ORDER BY ID_row;
drop table tmpActual_Time;

drop fields tmp1, tmp2; 

Regards