Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sarahguzman
New Contributor

How do i load data and create a new variable?

I keep getting errors below.

Can someone help me?

MAP_MUKESH_GRADE_TO_COUNTRY:

Mapping

LOAD Grade, Country;

SQL EXECUTE VLU_spGetLookUp 64, 'Conv Grade to Country Mukesh';

MAP_MUKESH_REGION_TO_COUNTRY:

Mapping

LOAD Region, Country;

SQL EXECUTE VLU_spGetLookUp 67, 'Region to Country';

RENAME TABLE DATA_FINAL TO TEMP;


NoConcatenate


DATA_FINAL:

LOAD *,

ApplyMap('MAP_MUKESH_GRADE_TO_COUNTRY', Grade,

ApplyMap('MAP_MUKESH_REGION_TO_COUNTRY', Region,

'*** Mukesh Missing Mapping ***')

) as MukeshCountry

RESIDENT TEMP;


DROP TABLE TEMP;



2 Replies

Re: How do i load data and create a new variable?

Can you show error image?

undergrinder
Valued Contributor II

Re: How do i load data and create a new variable?

Hi Sarah,

If this is the whole script, then the

RENAME TABLE DATA_FINAL TO TEMP;


can be a problem, because at this point you don't have table with name DATA_FINAL .


  • Share the error message would help a lot.
  • Comment out the whole code, and run it step by step if you can't localize where is the problem.
  • Are the store procedures config properly? Do they return dataset?

G.

Community Browser