topic Re: Mapping to one field with condition with in the table in QlikView

Mapping to one field with condition with in the table

rkpatelqlikview — Fri, 11 May 2018 12:04:52 GMT

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.

Re: Mapping to one field with condition with in the table

bhaskar_sm — Fri, 11 May 2018 12:58:24 GMT

HI,

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

Regards,

Bhasker

Re: Mapping to one field with condition with in the table

rkpatelqlikview — Fri, 11 May 2018 13:10:23 GMT

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]

------]

Re: Mapping to one field with condition with in the table

Anonymous — Fri, 11 May 2018 13:27:29 GMT

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.

Re: Mapping to one field with condition with in the table

rkpatelqlikview — Fri, 11 May 2018 14:03:37 GMT

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

Re: Mapping to one field with condition with in the table

rkpatelqlikview — Fri, 11 May 2018 16:51:06 GMT

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?

Re: Mapping to one field with condition with in the table

el_aprendiz111 — Sat, 12 May 2018 17:14:52 GMT

Hi,

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