Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Apply formula iteratively

Hi,   I have a table (info_table) with information I need to use to create a new column in a different table (data_table).    info_table promo_name start_date end_date AAA 01/12/2020 0...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a new column in data_table

     

    new column = coalesce(maxx(filter(info_table, info_table[start_date] <=data_table[date] && info_table[end_date] >=data_table[date]),[promo_name]),"None")

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a new column in data_table

 

new column = coalesce(maxx(filter(info_table, info_table[start_date] <=data_table[date] && info_table[end_date] >=data_table[date]),[promo_name]),"None")