TEST : Merge forms with different structure

Merging forms with different structure is very complex area, and really out of the scope of the functionality provided by ConfiForms TableViewMerger, but here is what could be done...

Data in form f1

text field will be used as key

myfield1

test 2
another 2
TEST MMM 23
112233 5
ewqfwef 12
4 4
test 24
another field 22
333 1
ANas 86
test 100
jjj 2
11 12
555 1
test 200
test 1000
qwerty 11
test88 88888888

Data in form f2

text field will be used as key

myfield2

test 3
Test MMM 34
TEST MMM 20
112233 33
4 4
tester 24
331 2
ANas 86
qwerty 22



Merging together, text field (same name) is as the grouping key

Merged column is configured like this 
Merged:(ZEROIFEMPTY("[entry.myfield2]") + ZEROIFEMPTY("[entry.myfield1]"))

text field will be used as key

Merged

test 1329
another 2
TEST MMM 43
112233 38
ewqfwef 12
4 8
another field 22
333 1
ANas 172
jjj 2
11 12
555 1
qwerty 33
test88 88888888
Test MMM 34
0
tester 24
331 2