Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1 Solution
Accepted Solutions
Hi,
I'm going to answer to your first use case scenario.
Please see the Screenshot JOB.
As you can see, I'm using tMap, tAggregate and tSort jsut to make the data sorted like you have in your OUtput sample. I haven't made any specific functions rather than using classical operation.
Let me describe the flow :
Step #1 : you have to start with the Metadata of your File; I use Integer for the DealID, and Double for the 2 other columns. (see MetadataForInput_File)
Step #2 : I'm using a tMap to add a new column named Cost which is the operation Quantity*Price (see tMap1)
Step #3 : I'm using the tAggregate component to group by DealId and sum each column Quanity and Cost (see tAggregate1)
Step #4 : then I'm using another tMap to Divide the sumCost by sumQuantity to get the Weighted average. (see tMap2)
Step #5 : I finally sort by Deal Id through the tSortRow. (see tSort)
Best regards;
I'm going to answer to your first use case scenario.
Please see the Screenshot JOB.
As you can see, I'm using tMap, tAggregate and tSort jsut to make the data sorted like you have in your OUtput sample. I haven't made any specific functions rather than using classical operation.
Let me describe the flow :
Step #1 : you have to start with the Metadata of your File; I use Integer for the DealID, and Double for the 2 other columns. (see MetadataForInput_File)
Step #2 : I'm using a tMap to add a new column named Cost which is the operation Quantity*Price (see tMap1)
Step #3 : I'm using the tAggregate component to group by DealId and sum each column Quanity and Cost (see tAggregate1)
Step #4 : then I'm using another tMap to Divide the sumCost by sumQuantity to get the Weighted average. (see tMap2)
Step #5 : I finally sort by Deal Id through the tSortRow. (see tSort)
Best regards;
Hi,
I'm going to answer to your first use case scenario.
Please see the Screenshot JOB.
As you can see, I'm using tMap, tAggregate and tSort jsut to make the data sorted like you have in your OUtput sample. I haven't made any specific functions rather than using classical operation.
Let me describe the flow :
Step #1 : you have to start with the Metadata of your File; I use Integer for the DealID, and Double for the 2 other columns. (see MetadataForInput_File)
Step #2 : I'm using a tMap to add a new column named Cost which is the operation Quantity*Price (see tMap1)
Step #3 : I'm using the tAggregate component to group by DealId and sum each column Quanity and Cost (see tAggregate1)
Step #4 : then I'm using another tMap to Divide the sumCost by sumQuantity to get the Weighted average. (see tMap2)
Step #5 : I finally sort by Deal Id through the tSortRow. (see tSort)
Best regards;
I'm going to answer to your first use case scenario.
Please see the Screenshot JOB.
As you can see, I'm using tMap, tAggregate and tSort jsut to make the data sorted like you have in your OUtput sample. I haven't made any specific functions rather than using classical operation.
Let me describe the flow :
Step #1 : you have to start with the Metadata of your File; I use Integer for the DealID, and Double for the 2 other columns. (see MetadataForInput_File)
Step #2 : I'm using a tMap to add a new column named Cost which is the operation Quantity*Price (see tMap1)
Step #3 : I'm using the tAggregate component to group by DealId and sum each column Quanity and Cost (see tAggregate1)
Step #4 : then I'm using another tMap to Divide the sumCost by sumQuantity to get the Weighted average. (see tMap2)
Step #5 : I finally sort by Deal Id through the tSortRow. (see tSort)
Best regards;