Forum Discussion

sahubibhuti45's avatar
sahubibhuti45
Helper I
2 years ago

Getting a row level operation by using two different tables

Hi Folks,   I have 2 tables like Loan Party name currency date org_amount john usd 15th jan 30 joy usd 16th jan 40 chandler aud 20th jan 20 monika eur 14th feb 4...
Need Help
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

sahubibhuti45 

ok. 

but if let us say you choose 20 of january, 

then all the data of the table Loan, should be multipled by the conversion amount of 20 of jan , respecting the currencies. 

 

is that right ? 

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

     sahubibhuti45 

    1. create a new column in both table as follow : 

    curreny_col_name & "|" & date 

     

    nB:  make sure that the date is written in the same format in both tables. 

     

    2.now you can link the 2 tables, on this column created . (  it should be a 1 to many relationship going from currency history table (1)  to loan table ( many ) 

     

    3. 

    from here, things should be easy. 

    you can create a new column in the loan table as  : related( curreny_history_table_name[ conversion amount col name] ) 

     

    now you have the conversion amount in your loan table. 

     

     

    hope this helps .

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠