Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional accumulative in Power Query

Hello, please help )   I need to change value (text type) from mapping table. But it is important to keep the filter  (not to use Merge table 😞 )   what I have Table1 Table 2   I...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    not very performant but one step

        replace = Table.ReplaceValue(
        Table1, 
        (o) => o[crf_form_id],
        (n) => n[Zones],
        (v, o, n) => 
            try Table2{[crf_form_id = o, number = n]}[decode]
            otherwise null,
        {"Zones"}
    )
dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

Hi, It is a bit confusing. Do you want to add Zones from Table2 to Table1  based on [keys crf_form_id] and [number]?
Provide expected results for some rows please.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your message, I tried to depict

    result

     

    • dufoq3's avatar
      dufoq3
      Icon for Community Champion rankCommunity Champion
      2 years ago

      You can achieve this wth Merge Queries

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        yes, it'll work... but the table has a lot of columns and the task requires not to use the function Merge