Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikconsultant
Contributor II

Replace the content of an column

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:00ANumberText

Number

Text
20.01.2013 08:19:00A......

...

...
20.01.2013 09:14:00B......

...

...
20.01.2013 09:33:00C......

...

...
20.01.2013 11:58:00A......

...

...

and an actual time table:

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

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

3 Replies

Re: Replace the content of an column

What is the substitution rule?

qlikconsultant
Contributor II

Re: Replace the content of an column

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

Not applicable

Re: Replace the content of an column

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

Community Browser