I have below columns -
I want a calculated field to be joined at the right of the column as
How to do this?
Script for division function and Joining function
May be this?
From <Data Source>;
Right Join (Sample)
Load *, Profit / CTS as WT%;
Yes, We can go same way. But, He mentioned one sentence over post. So that i came to know may be require Right Outer Join
I don't really understand what OP wants, but for what you have provided, I will not create a right join, but rather just create the new field in the same load.... Having said that, I don't really know the requirement....so you might be right