Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
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])?
In the load statement in the script alias your Field 1 to an unique fieldname:
[Field 1] as [New Field Name],
Hi Manish,
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..
Qualify Field1;
Load Field1, FIeld2 ... from TableName;
UnQualify Field1;
Okay, thanks