Accessing Values in Dictionary

Question

Hi team 
 I want to access values in a dictionary without using a loop , because in real-time we have 440 rows , and each row has 150 columns . Running a loop over each row to get values is causing performance issues. 
 I checked the Appian Community and found that we can use the a!keys() function to extract all keys 
 Id (PK), PartNumber, Status, Country_1, Country_2, Country_3, ..., Country_150 We are using CDT to get data from DB so output of CDT in dictionary format. Expected output: 
 countries: { 
 {country_1, country_2, country_3, ..., country_150}----for 1 st row 
 {country_1, country_2, country_3, ..., country_150}-----for 2nd row 
 } 
 *** One way i found is writing index on all 150 columns but it will increase code length is ther other alternative way other than this

Shubham Aware · Accepted Answer

Goddati Venkatesh said: Running a loop over each row to get values is causing performance issues. 
 Simply, Use dot-notation/index/property to extract all columns at once without loops. 
 Goddati Venkatesh said: One way i found is writing index on all 150 columns but it will increase code length is ther other alternative way other than this 
 Code length does NOT affect performance - only execution complexity does. Writing 150 dot notation or index() statements executes much faster than loops. Alternatively, Create an aggregated view: SELECT request_id, GROUP_CONCAT(country SEPARATOR ',') as countries_list FROM child_table GROUP BY request_id. Returns one row per request with comma-separated countries. In Appian: split(local!data.countries_list, ",").

Goddati Venkatesh · Answer

Thank you all for your time, 
 Shubham Aware 
 Create an aggregated view: SELECT request_id, GROUP_CONCAT(country SEPARATOR ',') as countries_list FROM child_table GROUP BY request_id. Returns one row per request with comma-separated countries. In Appian: split(local!data.countries_list, ","). 
 This is working fine and data loading without delay.

Harsha Sharma · Answer

Hi Goddati Venkatesh I am aware you have a solution now yet I feel I couldn&rsquo;t understand your usecase properly the other day and suggested to alter your existing view as solution. Though now I think a view is not needed /appropriate for your use case at all. 
 Instead of a view you can query country column from the child table by request id within Appian expression rule so that the output you receive (the country names) will be a list of strings. In your main rule where you are creating this dictionary with the countries, you can use the function joinarray() with separator as comma(,) like below. 
 joinarray (local!listOfCountries,&rdquo;,&rdquo;) 
 Here you need to replace the variable to variable that contains list of countries for given request id after querying data/ the expression rule that returns countries from child table. 
 This doesn&rsquo;t require a view and using a!foreach() you can get the expected output for each request id.

Accessing Values in Dictionary

Top Replies