Add manual data/values to script with data load from database

[JohanSOL]

Hi,

I have a scipt where I load all revenue/volumes/categories from our booking systems database. I'm now trying to add an variable price to this and need to do this manually since it does not exist in the booking system. What I want to trigger is when cargo A in harbour X is being transported this triggers an varible cost of Y$.

So my question is how can I add the cost of Y$ to the existing categories I have loaded from the database and create relationship between them, transported cargo A x Y$ = total variable cost for cargo / customer

Many thanks for the help!

Br,

Johan

[Yoshidaqlik]

Hi

Does this calculation need to be done a right data load?

you can use the "Resident" to do an analytical analysis and create a linked backing sheet

Something like

Table_1:
Load
 Gate,
 Value
From source;

Table_2
Load
Gate,
if(Sum(Value) > 20,2,3) as Cost_Variable
Resident Table_1
Group By Gate;

Hope this helps

regards