Applymap to replace multiple nested REPLACE ... possible?
The Basic issue I face is the following: I have several Charts with some measure and the Dimension "cost Center". The names of the cost Centers vary very much in length which is somewhat annoying in a Chart. So I thought of nested REPLACE() functions first. That worked.
Then I tried to implement a partial reload to avoid loading other big tables whenever I had thought of something new for that "Abbreviation_algorithm", but that didn't work - the REPLACE keyword before the LOAD seems to interact in some way with those REPLACE() functions - I got the message "field names must be unique in a table" - without having changed anything ...
So next I tried to map all the fields. The "map ... using" did not work out though maybe that would do the trick:
- I have a Loop where I load all the qvd_files that exist within a given Directory, with the Name that's in the filename.
- Before that Loop I wrote >> MAP [field1], [field2], [field3], [field4] using [mappingtable]; << (I had loaded the mappingtable using an inline mapping_LOAD beforehand) and after the Loop I had an >> Unmap; <<.
<=> That did not have any effect whatsoever. Maybe that doesn't work with a loading_Loop - can I somehow make that work?
Anyway, I also tried just using four individual Applymap() commands in a separate RESIDENT LOAD - but that did not work either, probably because I always have the alternatives for the individual elements of a cost_Center_Name in the mappingtable, not the whole Thing ...
Any help here would be much appreciated - I think I have a solution for what I actually wanted for this, though - by renaming one of the qvd_files in that Directory, it doesn't match the filelist anymore, it is not loaded and the whole Thing is much faster - at least for when I want to work on the script. To work on the GUI, I have to load all the data again ...
Re: Applymap to replace multiple nested REPLACE ... possible?
That's a good Approach, swuehl, possibly the right one, I'll have a look - what I want to replace (or map) is just substrings, elements of the Label, not the entire Label - that would be too much typework - example:
- Original Label is "Team Vergütungsabrechnung"
- I replace "Vergütungsabrechnung with "Verg.-abr." (I leave the word "Team" as it is)