Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When i use apply map function the resultant table can show this type :
[Country names map]:
Mapping LOAD * Inline [
short name,long name
Es,spain
Us,United states ];
Data:
Load *,ApplyMap('Country names map',[country code],'Unknown') Inline [
country code
Es
Uk
Us ];
Follow this thread for your concept
Hi,
Make sure you provide an space after mapping
MAP:
Mapping LOAD * Inline [
ShortName,LongName
Es,spain
Us,United states ];
Data:
Load *,ApplyMap('MAP',CountryCode,'Unknown') as Description;
Inline [
CountryCode
Es
Uk
Us ];
Regards
ASHFAQ
Hi All,
I want to map one field of a row table which is coming from a QVD file, with an Inline, Just to rename a columnsvalue (TERMINATION_REASON_KEY) with respective reference (TERMINATION_DESC). For that I created a Inline with one field name same as in the row QVD file and another is the reference. Now I am creating a chart and taking the reference as dimension.
Previously I am doing so and this is working well, but now the chart shows NULL in the reference field.
Please help