Mapping to one field with condition with in the table

[rkpatelqlikview]

Hi Experts,

Hope you are doing great.

Please find the attached QVW.

In this QVW i have done some level mappings in the Main tab and taking that Tab Qvd in to Main4.

I need to show the final DriverName from All these maps are to be done.

In Main4 tab, We have D1, D2,D3 and one more column  [Driver Name]. Here i need generate one final DriverNAme following this condition. consider the D1 first, If D1 there is a nulls then i should consider D2, If D2 get nulls  then D3 and then  [Driver Name],

I'm in trouble to find the FinalDriverNAme. Please let me know for more clarification.

[bhaskar_sm]

HI,

Can you clarify this "get nulls  then D3 and then  [Driver Name]," ??

Regards,

Bhasker

[rkpatelqlikview]

Hi Bhaskar,

Thanks for your respond. This was i did with Nested ApplyMaps but there is a one more challenging. In this final Applymap i have given DriverName even if not found in final level the it should show that

VehicleNumber & UnknownDriver. how to overcome this.

ApplyMap('Temp1', Do_Number, 

      ApplyMap('Temp2', Key2,

            ApplyMap('Temp3', VehicleNumber, [Driver Name]))) as D3,

Temp1:

Mapping Load Do_Number,  DriverNames Resident TripReport;

Temp2:

Mapping LOAD Key2, DriverNames Resident TripReport;

Temp3:

Mapping LOAD  VehicleNumber,DriverName3 Resident DriverMaster;

transafekm3:

LOAD

  ApplyMap('Temp1', Do_Number, 

      ApplyMap('Temp2', Key2,

            ApplyMap('Temp3', VehicleNumber, [Driver Name])))  as D3,

    Key2,

     Datums,

     Plant,

     [Carrier Code],

     [Carrier Name],

     [Vehicle Catagory],

     VehicleNumber,

     Do_Number,

    [Driver Name]

------]

[Anonymous]

Hi Kumar,

Your attachment doen'st have these ApplyMap that you provied in your answers, is there other .qvw more updated?

Either way, I have attached my solution, see if this helps you.

[rkpatelqlikview]

Yes. That's correct. If i gets the null in DriverName. It should show  "VehicleNumber & Unknown Driver"

[rkpatelqlikview]

Excellent Allison, Thanks for your great help.

Now i did this one with applymap. I'm attaching the Qvw. If the DriverNames data will get nulls at that it should show

  " VehicleNumber&Unknown ". I don't know how can we map this with in a table field.

and i need to fetch the some data from Both the table. Like DriverID,Plant1 from toptable and Driver Id and LicenceId from DriverMaster.

Used with Left Join. Is this right way to get the related data?

[el_aprendiz111 · Accepted solution]

Hi,

=if(len(trim(D1))=0 or if(len(trim(D2))=0,D3,D1),D3,D1)