topic Re: Check value in 3rd table in load script how? in QlikView

Check value in 3rd table in load script how?

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

I have a situation were I have table A & B loaded into memory, when I loading Table c I need to mask a value based on value from table A how do I do this? is lookup() or peek() would help

see image

Re: Check value in 3rd table in load script how?

sunny_talwar — Thu, 14 Dec 2017 17:32:40 GMT

I would say Mapping Table with ApplyMap

ApplyMap - script function ‒ QlikView

Don't join - use Applymap instead

Re: Check value in 3rd table in load script how?

rmuhammad — Thu, 14 Dec 2017 17:37:31 GMT

Mapping load require a key, Table A & C have no common key.

Re: Check value in 3rd table in load script how?

sunny_talwar — Thu, 14 Dec 2017 17:40:58 GMT

Group ID seems to be the same, no? Based on Group ID, you want to determine if Dept is 500 or 501 and then based on that you decide color

Re: Check value in 3rd table in load script how?

rmuhammad — Thu, 14 Dec 2017 17:51:58 GMT

Yes but Table C has Empl ID no Group ID and I am trying to do in the load script for the Table C

Re: Check value in 3rd table in load script how?

vishsaggi — Thu, 14 Dec 2017 18:12:03 GMT

What is your expected output in table C.?

Are you looking for something like this?

Try:

TableA:

Mapping LOAD GroupID, Dept INLINE [

GroupID, Dept, DeptDesc

10, 500, abc

11, 501, bbc

12, 502, cba

13, 563, aaa

14, 555, cab

15, 878, bbb

];

TableB:

LOAD *, ApplyMap('TableA', GroupID) AS ColorDept INLINE [

EmpID, GroupID

9595, 12

9999, 12

9000, 13

9990, 10

9001, 15

8999, 11

];

Used a background color expression to get the respective colors, you can change accordingly.

Re: Check value in 3rd table in load script how?

rmuhammad — Thu, 14 Dec 2017 18:53:22 GMT

Thanks for the help

along the same lines I applied map created new temp field and after loading table C using if condition resolved my issue. at the end dropped the temp field