Discussion board where members can get started with QlikView.
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
What is your expected output in table C.?
Are you looking for something like this?
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
LOAD *, ApplyMap('TableA', GroupID) AS ColorDept INLINE [
Used a background color expression to get the respective colors, you can change accordingly.
View solution in original post
I would say Mapping Table with ApplyMap
ApplyMap - script function ‒ QlikView
Don't join - use Applymap instead
Mapping load require a key, Table A & C have no common key.
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
Yes but Table C has Empl ID no Group ID and I am trying to do in the load script for the Table C
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