Join on basis of calculated column in Data foundation - IDT

[Former Member]

Hello,

I need to join a table with another table based on calculated columns.

When I join on basis of calculated column it gives an error, but if I directly do calculation in join expression it works fine.

Has anyone faced this issue ?

Regards,

Sneha Bajaj

[amitrathi239]

where are you calculating the column? can you share the error with join expression

[Former Member]

I just added concatenate function and created new field in table. So when I use this field in join condition I get error 'Error while compiling statement: failed.... Invalid column reference'. The calculated column which I have create doesn't throw any error but when I use it in join it throws error.

Anyways I have done work around and did calculations directly in join but I was just curious to know whether anyone has faced such issue.

Regards,

Sneha Bajaj