I know that for fields to be associated,the fields must have same name.I am using salesforce and in the script i wrote this:
sql select id as periodID,......from period__c;
sql select name as PeriodID,..... from Expenses__c;
because i want to associate name from one table to id of the other table,as name from expenses is a look-up to id from period__c.The type is same.But the script terminates with an error,i think it does allow aliasing.How can i achieve this by skipping aliasing.
yupi,i got it to work. the solution is this:
select transaction__c, category__c,Period__c,Montant__c, Date__c From expense__c ;
Load Period__c as Id,transaction__c, category__c,Period__c,Montant__c, Date__c
drop table expenses;