topic Re: How to change values when two tables joined? in QlikView

How to change values when two tables joined?

posywang — Thu, 12 May 2016 17:03:31 GMT

Hi,

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.

swuehl — Thu, 12 May 2016 17:16:18 GMT

Maybe use a MAPPING approach:

MAP:

MAPPING

LOAD Type, Source & '|' & Quality

FROM TableB;

LOAD

[PROD ID], Product, Type,

If(Left(Product), 'C', 'Bad', SubField(ApplyMap('MAP', Type),'|',2) ) as Quality,

SubField(ApplyMap('MAP', Type),'|',1) ) as Source

FROM TABLEA;

posywang — Thu, 12 May 2016 18:16:45 GMT

I added null() to formula since I do have some blank data but otherwise the solution is perfect! Thanks!