Field from specific Table

[#1]

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])?

[MK_QSL]

While loading the tables in script you can use

Qualify and UnQualify...

check below..

Qualify

[mvanlutterveld]

In the load statement in the script alias your Field 1 to an unique fieldname:

[Field 1]     as [New Field Name],

[#4]

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 ?

[MK_QSL]

You can do something like below..

Qualify Field1;

Load Field1, FIeld2 ... from TableName;

UnQualify Field1;

[#6]

Okay, thanks