


{"id":348000,"date":"2024-01-31T18:01:59","date_gmt":"2024-01-31T18:01:59","guid":{"rendered":"\/forum\/forums\/reply\/348000\/"},"modified":"2024-01-31T18:01:59","modified_gmt":"2024-01-31T18:01:59","slug":"348000","status":"publish","type":"reply","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/","title":{"rendered":"Reply To: Lookup table ansys composite prepost(Ansys ACP)"},"content":{"rendered":"<p>&lt;p&gt;Hello Chirag,&lt;\/p&gt;&lt;p&gt;If you have access to ACP, you should have access to the help:&lt;\/p&gt;&lt;p&gt;<img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png\" \/>&lt;\/p&gt;&lt;p&gt;&nbsp;&lt;\/p&gt;&lt;p&gt;There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&lt;\/p&gt;&lt;p&gt;&#8221;&lt;\/p&gt;&lt;h4 class=&#8221;bridgehead &#8220;&gt;Populating Look-Up Tables&lt;\/h4&gt;&lt;p&gt;The easiest way is to populate Look-up Tables is with the help of the&nbsp;<a title=\"1.3.4.2. Edit Entities with Excel\" href=\"https:\/\/ansyshelp.ansys.com\/Views\/Secured\/corp\/v241\/en\/acp_ug\/acp_gs_editexcel.html\" target=\"_self\" rel=\"noopener\">Edit&nbsp;Entities&nbsp;with Excel<\/a>&nbsp;on Windows. The set-up with exporting and importing a&nbsp;&lt;span class=&#8221;filename&#8221;&gt;<strong>.csv<\/strong>&lt;\/span&gt;&nbsp;file is similar and ideal for Linux. Data can also be entered into Look-up Tables using&nbsp;<a title=\"Chapter 6: The ACP Python Scripting User Interface\" href=\"https:\/\/ansyshelp.ansys.com\/Views\/Secured\/corp\/v241\/en\/acp_ug\/acp_chp_python_scripting.html\" target=\"_self\" rel=\"noopener\">The ACP Python Scripting User Interface<\/a>.&lt;\/p&gt;&lt;p&gt;There are three approaches to populating a Look-Up table. This can be done with:&lt;\/p&gt;&lt;div class=&#8221;itemizedlist&#8221;&gt;&lt;ul class=&#8221;itemizedlist&#8221; type=&#8221;disc&#8221;&gt;&lt;li class=&#8221;listitem&#8221;&gt;&lt;p&gt;<a title=\"2.1.7.1. 3D Look-Up Table With The Excel Link\" href=\"https:\/\/ansyshelp.ansys.com\/Views\/Secured\/corp\/v241\/en\/acp_ug\/acp_excel_link.html\" target=\"_self\" rel=\"noopener\">The Excel Link<\/a>&lt;\/p&gt;<\/li>\n<p>&lt;li class=&#8221;listitem&#8221;&gt;&lt;p&gt;<a title=\"2.1.7.2. 1D Look-Up Table with .csv Files\" href=\"https:\/\/ansyshelp.ansys.com\/Views\/Secured\/corp\/v241\/en\/acp_ug\/acp_lookup_csvfile.html\" target=\"_self\" rel=\"noopener\">Exporting\/Importing&nbsp;&lt;span class=&#8221;filename&#8221;&gt;<strong>.csv<\/strong>&lt;\/span&gt;&nbsp;Files<\/a>&lt;\/p&gt;<\/li>\n<p>&lt;li class=&#8221;listitem&#8221;&gt;&lt;p&gt;<a title=\"2.1.7.3. Look-Up Table with a Python Script\" href=\"https:\/\/ansyshelp.ansys.com\/Views\/Secured\/corp\/v241\/en\/acp_ug\/acp_lookup_python.html\" target=\"_self\" rel=\"noopener\">A Python Script<\/a>&lt;\/p&gt;<\/li>\n<\/ul>\n<p>&lt;p&gt;&#8221;&lt;\/p&gt;&lt;p&gt;Here is an example of a lookup table in Excel:&lt;\/p&gt;&lt;p&gt;<img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723542-mceclip1.png\" \/>&lt;\/p&gt;&lt;p&gt;You can import the above Excel table in ACP.&lt;\/p&gt;&lt;p&gt;&nbsp;&lt;\/p&gt;&lt;p&gt;And here is an example script to create a 1D lookup table in ACP:&lt;\/p&gt;<\/p>\n<pre class=\"programlisting\">table = db.active_model.create_lookup_table1d(name='LookUpTable1D.1')\ntable.origin=(0.0, 0.0, 0.0)\ntable.direction=(1.0, 0.0, 0.0)\ntable.create_column(name='Value', type='scalar')\ntable.dimensions=['length', 'dimensionless']\ntable.columns['Location'].values = [0., 1., 2., 3.]\ntable.columns['Value'].values = [0., 1., 2., 3.]&lt;br&gt;&lt;br&gt;Note that everything you do in the ACP GUI gets recorded as Python script at the bottom. So, you can create  &lt;br&gt;lookup tables manually and then modify the recorded script to do what you want.&lt;br&gt;&lt;br&gt;<img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723958-mceclip2.png\" \/>&lt;br&gt;&lt;br&gt;You can copy this script in a Python script file, for example myACPscript.py and replay it in ACP:&lt;br&gt;&lt;br&gt;<img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706724071-mceclip3.png\" \/>&lt;br&gt;&lt;br&gt;<\/pre>\n<p>&lt;p&gt;Give it a try and let me know how it goes.&lt;\/p&gt;&lt;p&gt;&nbsp;&lt;\/p&gt;&lt;p&gt;Reno.&lt;\/p&gt;&lt;\/div&gt;<\/p>\n","protected":false},"template":"","class_list":["post-348000","reply","type-reply","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&quot;Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Ansys Learning Forum | Ansys Innovation Space\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum\" \/>\n\t\t<meta property=\"og:description\" content=\"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&quot;Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-01-31T18:01:59+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-31T18:01:59+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&quot;Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/#listItem\",\"name\":\"Reply To: Lookup table ansys composite prepost(Ansys ACP)\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/#listItem\",\"position\":2,\"name\":\"Reply To: Lookup table ansys composite prepost(Ansys ACP)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum#listItem\",\"name\":\"Home\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#organization\",\"name\":\"Ansys Learning Forum\",\"description\":\"Ansys Innovation Space\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/#webpage\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/\",\"name\":\"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum\",\"description\":\"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:\\\"Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/reply\\\/348000\\\/#breadcrumblist\"},\"datePublished\":\"2024-01-31T18:01:59+00:00\",\"dateModified\":\"2024-01-31T18:01:59+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#website\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/\",\"name\":\"Ansys Learning Forum\",\"description\":\"Ansys Innovation Space\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum","description":"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:\"Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing","canonical_url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum#listItem","position":1,"name":"Home","item":"https:\/\/innovationspace.ansys.com\/forum","nextItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/#listItem","name":"Reply To: Lookup table ansys composite prepost(Ansys ACP)"}},{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/#listItem","position":2,"name":"Reply To: Lookup table ansys composite prepost(Ansys ACP)","previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum#listItem","name":"Home"}}]},{"@type":"Organization","@id":"https:\/\/innovationspace.ansys.com\/forum\/#organization","name":"Ansys Learning Forum","description":"Ansys Innovation Space","url":"https:\/\/innovationspace.ansys.com\/forum\/"},{"@type":"WebPage","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/#webpage","url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/","name":"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum","description":"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:\"Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/#website"},"breadcrumb":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/#breadcrumblist"},"datePublished":"2024-01-31T18:01:59+00:00","dateModified":"2024-01-31T18:01:59+00:00"},{"@type":"WebSite","@id":"https:\/\/innovationspace.ansys.com\/forum\/#website","url":"https:\/\/innovationspace.ansys.com\/forum\/","name":"Ansys Learning Forum","description":"Ansys Innovation Space","inLanguage":"en-US","publisher":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/#organization"}}]},"og:locale":"en_US","og:site_name":"Ansys Learning Forum | Ansys Innovation Space","og:type":"article","og:title":"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum","og:description":"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&quot;Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing","og:url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/","og:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png","og:image:secure_url":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png","article:published_time":"2024-01-31T18:01:59+00:00","article:modified_time":"2024-01-31T18:01:59+00:00","twitter:card":"summary_large_image","twitter:title":"Reply To: Lookup table ansys composite prepost(Ansys ACP) | Ansys Learning Forum","twitter:description":"Hello Chirag,If you have access to ACP, you should have access to the help: There are 3 ways to populate lookup tables in ACP. Here is more information from the help:&quot;Populating Look-Up TablesThe easiest way is to populate Look-up Tables is with the help of the Edit Entities with Excel on Windows. The set-up with exporting and importing","twitter:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2024\/01\/31-01-2024-1706723200-mceclip0.png"},"aioseo_meta_data":{"post_id":"348000","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"content","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":true,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2024-10-28 17:02:16","updated":"2026-08-14 16:35:30","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/innovationspace.ansys.com\/forum\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tReply To: Lookup table ansys composite prepost(Ansys ACP)\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/innovationspace.ansys.com\/forum"},{"label":"Reply To: Lookup table ansys composite prepost(Ansys ACP)","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/reply\/348000\/"}],"acf":[],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/replies\/348000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/replies"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/reply"}],"version-history":[{"count":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/replies\/348000\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=348000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}