topic How replace some values from an exception table to main table? in QlikView

How replace some values from an exception table to main table?

Anonymous — Wed, 15 Oct 2014 18:53:21 GMT

Hi, i have a Main Table with some value and i have an Exceptions Table that holds some exception values. For example, this table tell us that when Field1 value was 1, the Field2 value is 11. I can't do this with just the if statement because i have a lot of exceptions like this in the Exceptions Table.

Does anyone have some ideia on how to replace these exceptions' values into the Main Table??

Thanks!

Re: How replace some values from an exception table to main table?

MK_QSL — Wed, 15 Oct 2014 20:23:15 GMT

Use exception table as Mapping Load Table and use ApplyMap function in main table

Re: How replace some values from an exception table to main table?

maxgro — Wed, 15 Oct 2014 20:29:00 GMT

MapExceptions:

Mapping load * inline [

From, To

1,11

2,22

];

TmpMain:

load * inline [

Field1

];

Main:

NoConcatenate

load

ApplyMap('MapExceptions', Field1) as Field1

resident TmpMain;

DROP Table TmpMain;

Re: How replace some values from an exception table to main table?

Anonymous — Fri, 17 Oct 2014 20:01:35 GMT

Thanks! It works!

Re: How replace some values from an exception table to main table?

Anonymous — Fri, 17 Oct 2014 20:01:52 GMT

Thanks It Works!