How to generate one new column across three stages

[rkpatelqlikview]

Hi,

Please find the attached sample data. Please suggest on this.

There are 3 stages. from that stages i need to generate one new column that FinalPerson as shown in excel.

Thanks for your support.

[YoussefBelloum · Accepted solution]

Hi,

this is one way to do it

PFA

[rkpatelqlikview]

Thansk for your great help Youssef.

[rkpatelqlikview]

Thanks for your great help Youssef.

[rkpatelqlikview]

Hi Youssef,

The same scenario but D1 is having Level2,D2 is having Level3,D3 is having Level4. then I should take this data in to one field after if any empty cells it should take the data from DriverName after that there is a another level even if its nits still empty it shioud give

Vehicle Number.

Can i get this with same script, I used it in my back end? 

LOAD

      if(len(trim(D1))<>0 and (len(trim(D2))=0 or Len(trim(D2))='Level3') and (len(trim(D3 ))=0 or len(trim(D3 ))='Level4'), D1, 

      if((len(trim(D1))=0 or len(trim(D1))= 'Level2')  and len(trim(D2))<>0 and (len(trim(D3 ))=0 or len(trim(D3 ))='Level4'), D2,

      if((len(trim(D1))=0 or len(trim(D1))= 'Level2') and (len(trim(D2))=0 or Len(trim(D2))='Level3')  and len(trim(D3 ))<>0, D3

      ))) as Driver,      

    D3

    D2,

     D1,

     Key2,

     Datums,

    VehicleNumber ,

     [Driver Name]

FROM

(qvd);