Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Just wanted to know if there's an easy way ( Im guessing a map ) to do the folllowing :
So I have for instance
Date, Account_No , Salesperson
Now I have a separate list of 'Account_No' in an excel sheet. And it is only these account nos that should be picked up.
Manually I can do this by taking the list and concatenating with a comma at the end of each line and adding this to a where match clause in the script. Can this be done better ?
Try like this
Excel_Data:
LOAD Account_No
from excel
Date_Base:
LOAD Date,
Account_No ,
Salesperson
from data_base
where exists(Account_No,Account_No);
May be I think first you should load the valid account excel. Next, you load the Date, Account_No , Salesperson file and use Where clause as 'Where Exists(Account_No)'
Try like this
Excel_Data:
LOAD Account_No
from excel
Date_Base:
LOAD Date,
Account_No ,
Salesperson
from data_base
where exists(Account_No,Account_No);
Thanks Avinash - this works excellent
Cool...Happy to hear that