Joining a field with a formula

[#1]

Hello Fellow users.

Is it possible to Join a calculated field without to use a temp table?

regards,

Aissam

[#2]

I would say that you can, but looking through my apps, I couldn't find anything that would have been an easy test.

You should just have to name the field correctly and it will link.

Is this something that you tried and got unexpected results?

[#3]

I have 2 tables,

Table one:

Load

Job,

BillCode

from Excel dump;

------------------------------------------

Table two:

Job,

BillCodeNew,

If(len(BillCodeNew)> 0, BillCodeNew,BillCode) as BillCodeAllocation,

from Excel dump;

When I do this the system does not recognise BillCode. I tried on behave of your suggestion to add in table one:

'' as BillCodeAllocation

But I still receive the error message field <BillCode> not found.

regards,

Aissam

[#4]

You're formula uses data from another load. I was thinking you had all the data you needed within the load.

The problem is, BillCode does not exist in your second Excel sheet. If you can't get BillCode into your second Excel sheet, then I think you need to load everything together into an intermediate table before that formula would work.