thanks for the quick answer. It helped a lot
But one addtional question. Why is no table created in Qlikview?
I thought with the Code below, I would get a table called 'Map_Number_Codes'.
mapping LOAD Distinct
(ooxml, embedded labels, table is Tabelle1);
Do you know the reason, why such a table is not in Qlikview after loading?
I Need to have the Code and Description in a table and additionally use this as apply-map-source.
Thanks in advance.
Hi Christian, you can use the assitant to retrieve the data from Excel and creates the LOAD, you only need to add the 'Mapping' word before the 'LOAD' to create the mapping.
One issue you can found is that the numbers comes in a different format from the one you will look in ApplyMap(), in this case use Num() or Num#() to load with the desired format.
You can use it as any other mapping table:
Applymap(Map_Name, ValueToSearch, DefaultValue) as FieldName