Merging 2 field values to a new field value

[pradeep92]

Hi, I have different products say A,B,C etc.. I have requirement to have A , B and c is the new field value that should have the data with the sum of A and B. How do we do this ?

[AshutoshBhumkar]

Hi, Can you provide some example ?

[pradeep92]

Hi, I have given groupement details in a table .. Eg : Amelia,surpharm,totalfrance, rostra, zentiva are the field values in a FIELD called GROUPEMENT. So the user is making selections on field values and the data is coming correctly . Recently we added a totalfrance field value where it should contain the data for both summing up Amelia and surpharm when totalfrance is selected in listbox.

[jonathandienst]

Probably the best way to achieve this is to create another grouping field, associated with GROUPEMENT, which associates totalfrance with the two GROUPEMENT values that you require. The other GROUPEMENT values in the new group would simply associate with the same value.

Something like

LOAD *
Inline
[
    GROUPEMENT, NEW_GRPOUPEMENT
    rostra, rostra
    zentiva, zentiva
    totalfrance, totalfrance
    Amleia, totalfrance
    surpharm, totalfrance
    ...add more...
];

Now use the new field in the listbox place of GROUPEMENT.

[pradeep92]

Hi,

Thanks for the input . So this will sum up the data for total France but I should be having the other groupement as well separately . Please guide me on this scenario as well ?

[jonathandienst]

Not sure what you mean. Do you want to be able to select the components of totalfrance separately? Then you will need 2 listboxes, one for each of the groupings.

[pradeep92]

Hi,
Actually I would like to have the “totalfrance” field value along with zentiva,anemia,suropharm etc in the same listbox. We don’t have any data for totalfrance. But it should show the data for sum of anemia and suropharm when selected from listbox.

Please let me know if you need more details

[pradeep92]

A new field value is added to the same file where in totalfrance should contain the sum of 2 already existing field values

[pradeep92]

Hi,

I want the output like

LOAD * 
Inline
[
    GROUPEMENT, NEW_GRPOUPEMENT
    rostra, rostra
    zentiva, zentiva
    totalfrance, totalfrance // Should contain both sum of AMLEIA and SURPHARM data
    Amleia,  // AMELIA OLY
    surpharm, t// SURPHARM oly
    ...add more...
];