Deriving recordnum field by using existing fields

[chinnu123]

Hi Experts,

I am facing a issue in deriving a recordnum field.

For example

I am having a table which have fields

Incident I'd

Type

Month

Status

                                                                          O/P

Incident I'd.    Type.   Month. Status.          Recno

Inc123.            A.          Jan.      Open.             1

Inc123.             B.          Jan.      Open.             2

Inc123.              C.         Jan.        Open            3

Inc222               A.         Jan.        Open.           1

Inc333.               A        Feb.        Open.            1

Inc333.               B       Mar.        Open.            2

Inc444.               A.      Mar.        Open.            1

Inc444.               B.      Apr.        Open.             2

Inc444.               C.     Apr.         Open.             3

So by the above example we can see that the incident ids is repeating but type is different for incident I'd s so by using incident I'd and type we need to get record number.

Note: We need to do it in backend only.

Can any one help in this?

Thanks in advance

Thanks,

Chinnu.

Message was edited by: chinnu k

[sunny_talwar]

Use Left Join...

Left Join (FinalTable)

LOAD IncidentID,

Only(If((RecNo)=1,Type)) as test1,

Only(If((RecNo)=2,Type)) as test2,

Only(If((RecNo)=3,Type)) as test3

Resident FinalTable

Group By IncidentID;

[chinnu123]

Thanks sunny for your help. Its working fine now.