topic Re: Does my script correct ? in QlikView

Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 08:33:59 GMT

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 ??

Re: Does my script correct ?

Wed, 01 Apr 2015 08:37:34 GMT

Hey,

It should be

TableName:

Load

SalesPersonName,

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

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

resident table3 ;

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 08:40:46 GMT

Hey,

Yeah actually it was a typo after SalesPErsonName there is comma

Re: Does my script correct ?

Wed, 01 Apr 2015 08:45:13 GMT

Yes 🙂

Re: Does my script correct ?

MK_QSL — Wed, 01 Apr 2015 08:47:32 GMT

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;

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 09:18:09 GMT

yup,

i have mapping table. Thankx

Re: Does my script correct ?

MK_QSL — Wed, 01 Apr 2015 09:51:13 GMT

So what error you are getting?

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 09:57:38 GMT

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

Re: Does my script correct ?

jagan — Wed, 01 Apr 2015 09:58:01 GMT

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.

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 10:15:45 GMT

Thanks jagan

Re: Does my script correct ?

buzzy996 — Wed, 01 Apr 2015 10:23:17 GMT

ur script is correct!

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 12:34:18 GMT

hey,

if i am writting as :

Load SalesPErsonName1,

Applymap('Table1' , SalesPersonName , 'Unknown') as desk ;

It means that if SalesPersonName in Table1 = SalesPErsonName1 then it will put desk to corresponding value of desk byside to SalesPersonName. Isn't it ??

Re: Does my script correct ?

Anonymous — Wed, 01 Apr 2015 12:40:02 GMT

Nikhil ,

If you have huge data and want to verify your script syntax with few rows data.

You can go to 'Debug' and do a limited load. So that if any error is there your script will not take much time .

Thanks

BKC

Re: Does my script correct ?

nikhilgarg — Wed, 01 Apr 2015 12:45:00 GMT

btw can we use apply map instead of left join ?? will it give same result as left join give?

1: Load SalesPErsonName1,

Applymap('Table1' , SalesPersonName , 'Unknown') as desk ;

2: Load SalesPErsonName1

from table2;

Left Join

table1:

Load SalesPErsonName1,

desk ;

will 1 and 2 give same result ??

thanks

Re: Does my script correct ?

ganeshreddy — Wed, 01 Apr 2015 12:56:35 GMT

Hi Nikhil,

if you are having huge data, limit the load by using following example and do join or applymap then come to the conclusion.

First 10 LOAD * FROM abc.csv;

First (1) SQL SELECT * FROM Orders; //(Note: The parenthesis is allowed but not required.)

Regards,

Ganesh