You need to sign in to do that
Don't have an account?
Anupama
Exporting Data with Apex data loader.
When i exported data using the apex dataloader, the look up fields are exported as Ids, If they have to exported as exact names, what should be the query.
Although I may be wrong, I don't think the Export function in the data loader allows you to use join's in the query.
You can get around this by also exporting the objects you need to join to (including the ID and whatever fields you need from them) and performing the join with the target software.
You can get at the data.
For example if you are exporting account data and you wanted to get the account owner name:
Select Id, Name, Ownerid, Owner.name from Account
you would get the Account Id, the Account Name, the actuall Owner ID and the name of the owner.
Hope this helps you out.
The tables does not exactly parent-child relationship.What i have is the LokkUp field. It is like i want to store city name in one of my table and I refer it from City table. When I gave the query as suggested by you, it gave the error malformed query.
Provide more details. What object are you exporting from? Is it a custom object? What object are you trying to get the additional data from?
Post the query.
Yes, it is the custom object, the query formed using ApexDataLoader is "Select Id, OwnerId, IsDeleted, Name, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastActivityDate, Source__c, Destination__c, Flight_Name__c, Provider__c, Arrival__c, Departure__c, Class__c, Available_Seats__c, Booked_Seats__c FROM Aircraft__c " , Here Source__c, Destination__c are the LookUp fields from the another custom object Airport__c.
When the data is exported, it appears in the form
Sorry I am running blind as I am leaving for vacation today.
But try Airport__r.Source__c
The r is for a refrence field.