Does my script correct ?

[nikhilgarg]

Hey,

My script is:

Load SalesPersonName

ApplyMap('table1' , SalesPersonName , 'Unknown') as Desk,

ApplyMap('table2' , SalesPersonName , 'Unknown') as Region

resident table 3 ;

Is my syntax correct ??

[#2]

Hey,

It should be

TableName:

Load

SalesPersonName,

ApplyMap('table1' , SalesPersonName , 'Unknown') as Desk,

ApplyMap('table2' , SalesPersonName , 'Unknown') as Region

resident table3 ;

[nikhilgarg]

Hey,

Yeah actually it was a typo after SalesPErsonName there is comma

[#4]

Yes 🙂

[MK_QSL]

Assuming You Already have Mappling Load Table loaded before this table

table1:
Mapping Load SalesPersonName, Desk From FileName;

table2:

Mapping Load SalesPersonName, Region From FileName;

table3:
Load * From YourFileName;

NoConcatenate //Although it is not required, if your table3 don't have Desk and Region field.

table4:

Load

     SalesPersonName

     ApplyMap('table1' , SalesPersonName , 'Unknown') as Desk,

     ApplyMap('table2' , SalesPersonName, 'Unknown') as Region

resident table3;

Drop table table3;

[nikhilgarg]

yup,

i have mapping table. Thankx

[MK_QSL]

So what error you are getting?

[nikhilgarg]

No,

I am not getting any error. Before executing it i was just to confirm whether it is ryt or not because it takes much time to reload.

Thanks

[jagan]

Hi,

All FieldNames, TableNames and values in Qlikview are case sensitive.  So make sure that you have given the correct casing,  I seen this question in another post by you. 

First load select query and check the name of the fields and use the same field names in the preceding statements.

Hope this helps you.

Regards,

Jagan.

[nikhilgarg]

Thanks jagan