{"id":1175,"date":"2022-06-02T12:38:41","date_gmt":"2022-06-02T16:38:41","guid":{"rendered":"https:\/\/necando.com\/?p=1175"},"modified":"2022-08-02T14:24:04","modified_gmt":"2022-08-02T18:24:04","slug":"ibm-i2-analysts-notebook-offers-innovative-features","status":"publish","type":"post","link":"https:\/\/necando.com\/en\/2022\/06\/02\/ibm-i2-analysts-notebook-offers-innovative-features\/","title":{"rendered":"i2 Analyst&#8217;s Notebook offers innovative features"},"content":{"rendered":"<p><a href=\"https:\/\/necando.com\/en\/i2-group\/\">i2 Analyst&#8217;s Notebook<\/a> offers innovative features such as:<\/p>\n<ul>\n<li>connected network visualizations,<\/li>\n<li>social network analysis,<\/li>\n<li>geospatial or temporal views,<\/li>\n<li>And much more!<\/li>\n<\/ul>\n<p>These visual analysis tools help you uncover hidden connections and patterns in data.<\/p>\n<p><strong><span style=\"color: #f4436c\">Here are the steps to use the feature import Specification with condition TRUE or FALSE<\/span><\/strong><\/p>\n<p>When a dataset carries a value of TRUE or FALSE, the analyst can decide whether it needs to be imported on the chart using \u201cColumn Actions\u201d as a mechanism. Either they can decide to not import the dataset if the value is FALSE or import it with certain characteristics such as Attributes.<\/p>\n<p>To make sure the steps to Import Specification are clear, we will use a sample dataset.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1225\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___1.png\" alt=\"\" width=\"407\" height=\"185\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___1.png 407w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___1-300x136.png 300w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>In this sample dataset, we have a series of companies including shell companies. Any company with a value of FALSE is represented as a \u201cShell Company\u201d. We want to import the data to indicate companies with the value of FALSE as a unique entity, easily identified on the chart with \u201cNo Identity\u201d or \u201cLabel\u201d.<\/p>\n<p>1. Open Analyst\u2019s Notebook and go to \u201cHome\u201d then to \u201cImport\u00bb, \u201cImport from File\u201d and select your source file.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1228 size-medium\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___2-300x200.png\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___2-300x200.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___2.png 451w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>2. In the \u201cImport Specification\u201d, after the step \u201cSelect Worksheet\u201d and \u201cSelect Row\u201d, go to \u201cColumn Actions\u201d.<\/p>\n<p>3. Create a new column called \u201cImport_Conditon\u201d and join the columns \u201cisUnique_Importer\u201d[Coma]\u201dImporter\u201d. The results should look like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1230 size-full\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___3.png\" alt=\"\" width=\"219\" height=\"152\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1240\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___8.png\" alt=\"\" width=\"159\" height=\"131\" \/><\/p>\n<p>4. Alternatively, create another column to be used as a \u201cLabel\u201d for your identities, knowing that some cells might be empty based on the value False, as seen below.<\/p>\n<p>5. In the \u201cAvailable Actions\u201d section, select \u201cReplace value\u201d and push it to the right in the \u201cAction Applied\u201d section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1234 size-medium\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___5-300x292.png\" alt=\"\" width=\"300\" height=\"292\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___5-300x292.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___5.png 420w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>6. In the \u201cReplace Value\u201d section, select your matching text i.e. \u201cAquarium Services Warehouse\u201d, (ignore case) and \u201cReplace with\u201d leave it blank.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1256\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___6-1.png\" alt=\"\" width=\"267\" height=\"142\" \/><\/p>\n<p>7. Under the section \u201cApply only when the following conditions are met\u201d, select the condition \u201cStarts with\u201d from the list and in the \u201cValue\u201d section, write the word \u201cFALSE\u201d as per the sample data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1238\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___7-1024x96.png\" alt=\"\" width=\"1024\" height=\"96\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___7-1024x96.png 1024w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___7-300x28.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___7-768x72.png 768w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___7.png 1194w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>This will create a blank cell in the new column called \u201cImporter_condition\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1232\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___4.png\" alt=\"\" width=\"159\" height=\"131\" \/><\/p>\n<p>8. In the \u201cAssign Columns\u201d, assign the \u201cimporter condition\u201d column to the \u201cIdentity of your entity\u201d. Since there is a blank cell, created from the \u201cColumn Action\u201d it will create a warning sign as per the sample below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1248 size-medium\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-300x115.png\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-300x115.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-1024x394.png 1024w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-768x295.png 768w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11.png 1241w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>In your \u201cLabel\u201d cell, insert the \u201cimport condition clean\u201d which was created to ensure that only the label with a \u201cTRUE\u201c value remains in that column.<\/p>\n<p>9. To demonstrate entities with a value of FALSE as an entity on your chart, that is an entity with no identity or label, select the ellipsis beside the name of the column \u201cimporter condition\u201d as shown above.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1246 size-medium\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___1048-300x260.png\" alt=\"\" width=\"300\" height=\"260\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___1048-300x260.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___1048.png 416w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>10. Select the second option \u201cCreate the entity with a blank identity\u201d. This will force Analyst\u2019s Notebook to create an entity on your chart with no identity or label based on the value \u201cFALSE\u201d added earlier in the \u201cColumn Actions\u201d section.<\/p>\n<p>11. In the \u201cLabel\u201d section, select the column \u201cImporter condition clean\u201d to add a name to each entity. This new column displays ONLY the company with the value \u201cTRUE\u201d so it can be used as a label.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1248\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-1024x394.png\" alt=\"\" width=\"900\" height=\"346\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-1024x394.png 1024w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-300x115.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11-768x295.png 768w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___11.png 1241w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>12. As an option, you can add an attribute for statistical analysis value on the chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1221\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/image_ANB_101___14-1024x343.png\" alt=\"\" width=\"900\" height=\"301\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/image_ANB_101___14-1024x343.png 1024w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/image_ANB_101___14-300x100.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/image_ANB_101___14-768x257.png 768w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/image_ANB_101___14.png 1112w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>13. As a result, on your chart, all entities that have no label based on the value \u201cFALSE\u00bb will be identified. Further to the analysis, entities can be formatted using a frame to indicate FALSE in red and TRUE in green.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1252 size-medium\" src=\"https:\/\/necando.com\/wp-content\/uploads\/2021\/12\/Import_spec___13-300x225.png\" alt=\"\" width=\"300\" height=\"225\" srcset=\"https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___13-300x225.png 300w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___13-768x577.png 768w, https:\/\/necando.wpenginepowered.com\/wp-content\/uploads\/2021\/12\/Import_spec___13.png 923w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>And that\u2019s how you <em>Import Specification with true or false!<\/em><\/strong><\/p>\n<p>At Necando Solutions, our experts work with you from strategy to project execution and will support you to enhance your investigations and crime prevention capabilities.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>i2 Analyst&#8217;s Notebook offers innovative features such as: connected network visualizations, social network analysis, geospatial or temporal views, And much [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_seopress_robots_primary_cat":"none","_seopress_titles_title":"","_seopress_titles_desc":"There are many ways to identify key entities within i2 Analyst\u2019s Notebook. The Selection Sets function in the Select menu is also a great option!","_seopress_robots_index":"","content-type":"","inline_featured_image":false,"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1175","post","type-post","status-publish","format-standard","hentry","category-i2-analysts-notebook-2"],"acf":[],"_links":{"self":[{"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/posts\/1175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/comments?post=1175"}],"version-history":[{"count":0,"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/posts\/1175\/revisions"}],"wp:attachment":[{"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/media?parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/categories?post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/necando.com\/en\/wp-json\/wp\/v2\/tags?post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}