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

[buzzy996]

ur script is correct!

[nikhilgarg]

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

[Anonymous]

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

[nikhilgarg]

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

[ganeshreddy]

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