Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to cleaning records and need some help to achieve my expected output below.
I have table1 and table2, I need to build a 3rd table as shown below based on the first 2 tables.
Table1:
values | number |
ab | 12 |
cd | 34 |
ef | 42 |
gh | 76 |
Table2 | |
cat | values2 |
1 | (cd&gh)-ef |
2 | ab+ef |
Expected Table
Cat | Defined |
1 | (Sum({<values={'cd'}>}number)+Sum({<values={'gh'}>}number))-Sum({<values={'ef'}>}number) |
2 | Sum({<values={'ab'}>}number)+Sum({<values={'ef'}>}number) |
Thanks for your assitance