lookup or peek?

[jagan]

Hi,

Try like this

LOAD

*,

If(Previous(TOP_manager) <> TOP_manager, 1, Peek('Experience') + 1)  AS Experience;

LOAD

*

FROM DataSource

ORDER BY TOP_manager, [salary month];

Hope this helps you.

Regards,

Jagan.

[#2]

Emmmm.... I've no field "Experience" in the original table.... what will it peek in this case?....

[jagan]

Hi,

Experience is the new field which we arrived, did you tried executing the script?

Regards,

Jagan.

[#4]

I've tried///it doesnt work....

TOP:

LOAD salary_month,

    Object_ID,

     TOP_manager

FROM

[\\qv\..\TOP.xlsx]

(ooxml, embedded labels, table is [01salary (1)]);

LEFT JOIN

LOAD

TOP_manager,

Date(Min(salary_month)) AS Start

RESIDENT TOP

GROUP BY TOP_manager;

Experience_tab:

LOAD

*

RESIDENT TOP

ORDER BY TOP_manager, salary_month;

left join LOAD

TOP_manager,

If(Previous( TOP_manager) <>  TOP_manager, 1, (Peek('Experience') + 1))  AS Experience

resident Experience_tab;

the error is :" Experience_tab" not found/...

Whats my error in script, can you tell me, please?

[#5]

Solved that by using ""1 as Experiense", and than left join with

If(Previous(TOP_manager) <> TOP_manager, 1, Peek('Experience') + 1)  AS Experience;

It doesnt work=( just doesnt evaluate, Everywhere Experience is still 1 =(