Hi Sir,I am stuck and not able to proceed in loading attached file 
country-code.xlsx file using following command:country_data_load = LOAD 
'/user/rvpai427385/Pig_Labs/Zomato_Analysis/Country-Code.xlsx' using 
org.apache.pig.piggybank.storage.CSVExcelStorage(',', 
'NO_MULTILINE', 'NOCHANGE', 'SKIP_INPUT_HEADER');dump 
country_data_load;It should load only 12 rows consisting of 12 country codes 
and 12 country names but that is not happening.It is loading junk data and not 
the 12 country data which we want.Can you please check below command and advise 
?  

Attachment: Country-Code.xlsx
Description: MS-Excel 2007 spreadsheet



Reply via email to