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"}
    )
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

dufoq3's avatar
dufoq3
Community Champion
2 years ago

If you don't want use Merge, you can achieve the same by adding this as custom column to Table1.

 

Table.SelectRows(Table2, (x)=> x[crf_form_id] = [crf_form_id] and x[number] = [Zones])[decode]{0}?

 

To be honest I don't understand why don't you want use merge - it is faster solution.