Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am familiar with the function but have encountered one strange issue with the ApplyMap function I like a lot. Suddenly it does not link correctly two exactly the same values in the mapping load and load fact for some lines. For example, if I check values created I get this:
CodeFile
"AB-1234" "Description 1234"
"AC-4321" "Description 4321"
Fact
ApplyMap('CodeFile', 'AB-1234', '<Empty>') returns Description BUT ApplyMap('CodeFile', 'AC-4321', '<Empty>') returns <Empty>.
I need to say that those CodeFiles and Facts are loaded into one QV table from the year dependent tables, i.e. CodeFile11 and CodeFile12 and Fact11 and Fact12. I tried to include Year into to key but then it didn't work at all. I've also tried to use text() and trim(text()) but no luck.
I am still on the version 9 SR4.
Thanks for ideas,
Nenad
Do not bother. I've sorted it out
As I have two for...next loops I had to add a Year variable to the name of the mapping loads. For example: mapping load Other_Map$(Y)$(vC): and then add a Year into the key like here '$(Y)-$(vC)-'&Field1 as OtherID, and then use the same notation in the ApplyMap function, applymap('Other_Map$(Y)$(vC)', '$(Y)-$(vC)-'&Field2, '<Empty>')
Hi Nenad,
Two quick questions: is there any chance that fact or codefile tables are being concatented implicitly but unexpectedly? And this leads to the second: is there any change that there is more than one description for one given CodeFile?
Hope that helps.
Miguel
Do not bother. I've sorted it out
As I have two for...next loops I had to add a Year variable to the name of the mapping loads. For example: mapping load Other_Map$(Y)$(vC): and then add a Year into the key like here '$(Y)-$(vC)-'&Field1 as OtherID, and then use the same notation in the ApplyMap function, applymap('Other_Map$(Y)$(vC)', '$(Y)-$(vC)-'&Field2, '<Empty>')