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

[Anonymous]

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!

[MK_QSL · Accepted solution]

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

[maxgro]

MapExceptions:

Mapping load * inline [

From, To

1,11

2,22

];

TmpMain:

load * inline [

Field1

1

2

3

4

5

6

7

];

Main:

NoConcatenate

load

  ApplyMap('MapExceptions', Field1) as Field1

resident TmpMain;

DROP Table TmpMain;

[Anonymous]

Thanks! It works!

[Anonymous]

Thanks It Works!