Confusion with data display in the Min,Max,Median columns(under value) in data Profiling in SAP BOIS

[former_member188628]

Hi All

      I was trying out the "Column profiling" option in the SAP-BOIS tool. There is a field called "LANDX" with the unique country name values as shown below:-

Sample values under the LANDX column:-

The Min, Max,Median value displayed by the Infosteward tool:

I am confused Why the value "Germany" is displayed as low value, why "Libya" the median,and "Zimbabwe" as the high?I mean with other numeric value fields the logic was straightforward, but i am confused in case of such string values. Please help me in clarifying the confusion

[mageshwaran_subramanian · Accepted solution]

Is 'Germany' starts with a space?

It is sorted alphabetically.

Post your Information Steward questions here

[former_member187605 · Accepted solution]

Value are alphabetically sorted from A to Z. That's why Zimbabwe is the high value. Lybia is right somewhere in the middle.

You have a problem with Germany, because it has a leading blank (and blanks come before any letter).

That's the whole idea behind data profiling. It helps you in identifying anomalies, just as this one .

[former_member188628 · Accepted solution]

Hi Dirk

          The answer was just cool.Wow,Thanks a lot...Yes there is a space before Germany,and hence it was considered as lowest value,and accordingly others have been formulated.

Thanks

Regards

Moumita

[former_member188628 · Accepted solution]

Hi Dirk

      The confusion still lies with the calculation of median values across the LANDX data,I tried calculating the Median:

Case1: For Overall Records:-

252\2(Even- Total Count)

126=Kazakhstan

(126 + 127 )\2 = 126.5

Accordingly the output should be:-

Kazakhstan

or Laos

Case2:-

Records starting from -"Germany" and "Zimbabwe"

194

Median:-97

(97+96)/2 =96.5

Montserrat

or Malta

How Libya??Please explain this

Below is the complete LANDX data(252 records)

[former_member187605 · Accepted solution]

Median = the middle value of a given number of rows.

I cannot possible derive from a screenshot whether the calculation in IS is correct or not, I would need the data in text format for doing so.

But I assume it is ,

[former_member188628 · Accepted solution]

Hi Dirk

     I have inserted the "LANDX" field data in the table below;Please help me out for the median value

LANDX

Andorra Utd.Arab Emir. Afghanistan Antigua/Barbuda Anguilla Albania Armenia Dutch Antilles Angola Antarctica Argentina Samoa, America Austria Australia Aruba Aland Islands Azerbaidan Bosnia-Herz. Barbados Bangladesh Belgium Burkina Faso Bulgaria Bahrain Burundi Benin St Barthélemy Bermuda Brunei Dar-es-s Bolivia Bonaire, ST. EU Brazil Bahamas Bhutan Bouvet Islands Botswana Belarus Belize Canada Cocos Islands Dem. Rep. Congo Central Afr.Rep Congo Switzerland Ivory Coast Cook Islands Chile Cameroon China Colombia Costa Rica Cuba Cape Verde Curaçao Christmas Islnd Cyprus Czech Republic Germany Djibouti Denmark Dominica Dominican Rep. Algeria Ecuador Estonia Egypt West Sahara Eritrea Spain Ethiopia Finland Fiji Falkland Islnds Micronesia Faroe Islnds France Gabon United Kingdom Grenada Georgia French Guiana Guernsey Ghana Gibraltar Greenland Gambia Guinea Guadeloupe Equatorial Guin Greece S. Sandwich Ins Guatemala Guam Guinea-Bissau Guyana Hong Kong Heard/McDon.Isl Honduras Croatia Haiti Hungary Indonesia Ireland Israel Isle of Man India Brit.Ind.Oc.Ter Iraq Iran Iceland Italy Jersey Jamaica Jordan Japan Kenya Kyrgyzstan Cambodia Kiribati Comoros St Kitts Nevis North Korea South Korea Kuwait Cayman Islands Kazakhstan Laos Lebanon St. Lucia Liechtenstein Sri Lanka Liberia Lesotho Lithuania Luxembourg Latvia Libya Morocco Monaco Moldova Montenegro Saint Martin Madagascar Marshall Islnds Macedonia Mali Myanmar Mongolia Macau N.Mariana Islnd Martinique Mauritania Montserrat Malta Mauritius Maldives Malawi Mexico Malaysia Mozambique Namibia New Caledonia Niger Norfolk Islands Nigeria Nicaragua Netherlands Norway Nepal Nauru Niue New Zealand Oman Panama Peru Frenc.Polynesia Pap. New Guinea Philippines Pakistan Poland St.Pier,Miquel. Pitcairn Puerto Rico Palestine Portugal Palau Paraguay Qatar Reunion Romania Serbia Russian Fed. Rwanda Saudi Arabia Solomon Islands Seychelles Sudan Sweden Singapore Saint Helena Slovenia Svalbard Slovakia Sierra Leone San Marino Senegal Somalia Suriname South Sudan S.Tome,Principe El Salvador Sint Maarten Syria Swaziland Turksh Caicosin Chad French S.Territ Togo Thailand Tajikistan Tokelau Islands Timor-Leste Turkmenistan Tunisia Tonga Turkey Trinidad,Tobago Tuvalu Taiwan Tanzania Ukraine Uganda Minor Outl.Isl. USA Uruguay Uzbekistan Holy See St. Vincent Venezuela Brit.Virgin Is. US Virgin Islnd Vietnam Vanuatu Wallis,Futuna Samoa Kosovo Yemen Mayotte South Africa Zambia Zimbabwe Multiple CoO

Regards

Moumita

[former_member187605 · Accepted solution]

If you sort these 252 countries alphabetically, Lybia will be right in the middle:

There's your median .

[former_member188628 · Accepted solution]

Hi Dirk

Thanks a lot,for your response.I cross checked and agree upon the same

Thanks

Regards

Moumita