I have 2 table with same field name, is it possible for me to select field from specific table and use it expression?
For example,count( [Table 1].[Field 1])?
While loading the tables in script you can use
Qualify and UnQualify...
Thanks you for your help, it works, but is it possible not to do that in the load editor? because i still need to join some of fields together. is it possible to load normally and when comes to expression do something like table1.field2 ?
You can do something like below..
Load Field1, FIeld2 ... from TableName;
In the load statement in the script alias your Field 1 to an unique fieldname:
[Field 1] as [New Field Name],
Retrieving data ...