Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
vikas_nandanwar
Creator II
Creator II

Division function

Hi,

I have below columns -

CTSCostPerCtsvalueExpPrfi%ProfitBrokerage

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

6 Replies
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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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
Partner - Champion
Partner - Champion

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

Andy

vikas_nandanwar
Creator II
Creator II
Author

Done Thanks for the help