Discussion Board for collaboration on QlikView Scripting.
I have two tables and the 2nd table left join the first one. My question is how to change value in Quality based on value in Product?
For example, if Product name starts with "C", change value of Quality to "Bad". Please let me know. Thanks.
Go to Solution.
Maybe use a MAPPING approach:
Don't join - use Applymap instead
LOAD Type, Source & '|' & Quality
[PROD ID], Product, Type,
If(Left(Product), 'C', 'Bad', SubField(ApplyMap('MAP', Type),'|',2) ) as Quality,
SubField(ApplyMap('MAP', Type),'|',1) ) as Source
I added null() to formula since I do have some blank data but otherwise the solution is perfect! Thanks!