Calculating KRI weights across the dataset

[sriniprad08]

Hi Team,

Hope you are well. I need help.

I need to add a column at the end based on the weights across each country. 

Please find attached  . Please let me know how to go about this,

Thanks and Regards,

Srinivas

[binuacs · Accepted solution]

@sriniprad08 One way of doing this

1. Keep your KRI Weigh values in separate input file and make sure the fields names are matching with the input file 

2. Transpose the first input file only the numeric fields in Data Columns and rest of the fields should be in the key columns

3. Join with the input 2 with the same field names of the numeric fields and the Name field from the Transpose tool

4. Sort based on the city

5. Add the formula tool to calculate the corresponding country risk by multiplying the KRI weigh and the input value

6. Take the total sum by grouping the city field 

7. join back with the input file with the key city

[sriniprad08]

Hi @binuacs ,

Perfect. Thank you so much :)

Happy Easter.

Regards,

Sri