Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Having a field with some details, now i want to consider total of multiple values as a new field value

Having a field with some details, now i want to consider total of multiple values as a new field value

let say, i have a field Product


Table with fields

Tab1:

Country

Product

Physician

Now data in Product filter available as  below

Product

Isentress

Tivicay

Intelence

Edurant

Reyataz

Prezista

Atripla

Eviplera

Stribild

Triumeq

Rezolsta

Evotaz

Genvoya

Odefsey

Symtuza

Juluca

Biktarvy

////// Expected data to Add in filter with the above details

Total darunavir

Total elvitegravir

Total elvitegravir

and i want to Add in Product filter as new values like (In backend script part need to be handled)

Total darunavir (Prezista+ Rezolsta+Symtuza)

Total dolutegravir (Tivicay+ Triumeq+Juluca)

Total elvitegravir (Stribild+ Vitekta+Genvoya)

Some one can help out of this

Regards,

Kakani.

stalwar1

tresesco

3 Replies
kakani87
Specialist
Specialist
Author

Kindly share the script as I'm having personal edition

Regards,

Kakani.

tresesco
MVP
MVP

Have a look here: Generic keys

dx_anupam
Creator
Creator

Hi Sai,

I think best way to achieve this is by using apply map load.

below link might help you out

Data Cleansing

Regards,

Anupam