topic how to Mapping Load an inline data? in QlikView

how to Mapping Load an inline data?

jim_chan — Thu, 22 Sep 2016 09:05:58 GMT

Hi guys,

I want to mappiny load this inline data. After added with the mapping function and reloaded the data, but i can't see this table anymore.

Is the Mapping function wrong?

tabRiskColours:

Mapping

LOAD Dual(Risk,AutoNumber(Risk,'Risk')) as Risk,

RGB(R,G,B) as RiskColour

Inline [

Risk,R,G,B

HIGH ,255,153, 51

MEDIUM ,255,204, 0

LOW ,255,255,153

];

Rgds

Jim

Re: how to Mapping Load an inline data?

avinashelite — Thu, 22 Sep 2016 09:11:06 GMT

Mapping table will be automatically get deleted at the end of the script , so you will be not able to see the table after the reload

Re: how to Mapping Load an inline data?

sunny_talwar — Thu, 22 Sep 2016 09:14:41 GMT

Avinash is right, you can use the MappingLoad to do a ApplyMap in a particular reload, but it won't survive the reload. As soon as the reload is finished, your mapping table is dropped off automatically. Are you doing any ApplyMap using this mapping table?

Re: how to Mapping Load an inline data?

Digvijay_Singh — Thu, 22 Sep 2016 09:19:31 GMT

If you want table to appear in your data model then remove the word Mapping, I mean load as a normal table. You can use lookup() instead of applymap to get field values from other table but that is not recommended.