Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to Mapping Load an inline data?

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

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

3 Replies
avinashelite

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

sunny_talwar

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?

Digvijay_Singh

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.