Cross Join

[#1]

Hello,

I am trying to calculate a new value by multiplying two fields from 2 different tabs of the excel input. The sample QVW file and the Excel input are attached here. Please give me your suggestions.

Please let me know if more information is needed.

Expected Output:

Actual Value is from the Sheet:Forecast Final

Percentage from Sheet:Allocation Percentage Final

Thanks.

[sunny_talwar]

Not very clear as to what you are looking to do. Can you may be explain what you are looking to do?

[#3]

Sunny,

My input data is split across 2 tabs of Excel input.So my requirement is to get the values from "Forecast Final" sheet for a combination of Country Code and Year Month and split it across the dates from the sheet "Allocation Percentage Final" by multiplying it.

For example, from the picture below, the forecast amount from "Forecast Final" sheet should be multiplied with the data column so that the full amount for that particular Year Month gets split across dates for that month.

Thanks.

[#4]

Hello, any suggestion to achieve is highly appreciated.

Thanks.