Division function

[vikas_nandanwar]

Hi,

I have below columns -

CTS

CostPerCts

value

ExpPrfi%

Profit

Brokerage

I want a calculated field to be joined at the right of the column as

WT% =Profit/CTS

How to do this?

Script for division function and Joining function

Please help

[Anil_Babu_Samineni]

May be this?

Sample:

Load CTS,

        CostPerCts,

        value,

        ExpPrfi%,

        Profit,

        Brokerage

From <Data Source>;

Right Join (Sample)

Load *, Profit / CTS as WT%;

Resident Sample;

[sunny_talwar]

Why do you need a join Anil? Why not just this

Sample:

Load CTS,

        CostPerCts,

        value,

        ExpPrfi%,

        Profit,

        Brokerage,

        Profit / CTS as WT%

From <Data Source>;

[Anil_Babu_Samineni]

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

[sunny_talwar]

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

[awhitfield]

Hi I am with sunny here, in this case I think 'joined' means 'added'

Andy

[vikas_nandanwar]

Done Thanks for the help