Discussion board where members can get started with Qlik Sense.
I have a table with values and in the load script i have a list with the Translation of the value
Now I want the text in the Value 1 column
How can I reach this?
May be using ApplyMap and Mapping Load
LOAD * INLINE [
ApplyMap('MappingTable', [Value 1], Null()) as [Value 1];
Order, Value 1
But I have already loaded a Table from a database where I have Value 1 as a field. that I want to replace
Yes, so what is the problem?
I have something like that:
Text([DEPOT_ID]) as [Depot],
[MODTIME] AS [BI_DEPOT.MODTIME],
APPLYMAP( '__countryCodeIsoTwo2Polygon', UPPER([COUNTRY_CODE]), '-') AS [BI_DEPOT.COUNTRY_CODE_GeoInfo];
SQL SELECT "DEPOT_ID",
Now I want to replace ID with F2 from the mapping table for the case that ID Matches F1
Something like this
ApplyMap('MappingTable', [ID], Null()) as [ID],
hmm... I am getting an error :-(
ApplyMap error:map_id not found
You did add the MappingTable before the BI_DEPOT load, right?
Can you share the exact script you are using?