How do i load data and create a new variable?

[Anonymous]

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;

[Anil_Babu_Samineni]

Can you show error image?

[undergrinder]

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.