Why the ApplyMap does not work when concatenation is used?

[#1]

XY_Map:
mapping load
'$(vComp)'&'-'&FIELD1 as ID,
FIELD1&'-'&FIELD2 as Desc;
select FIELD1, FIELD2 from SQL_TABLE;

Fact:

load

...

applymap('XY_Map', '$(vComp)'&'-'&left(FIELD99,7)) as Desc,

...

select FIELD99 from SQL_FACT_TABLE;

[swuehl · Accepted solution]

Hi all,

I just gave the mapping tables a unique name (vComp for example). Seems to work now.

See attached.

Regards,

Stefan

[#3]

Thank you Stefan. I would not guess that as I've seen correct records in the Table Viewer when I ommited the 'mapping' part. Anyway, thank you very much for your help.

Regards,

Neno