How to map the data with in a table

[rkpatelqlikview]

Hi Qlik,

Can any one  help on this please.

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 still empty it should give

Vehicle Number.

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

Below i tried its not working.

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);