-
Recently active
I have a requirement where User wants to extract any Pdf value whose format is not fixed. Means invoice or any other Pdf will be different ?. if yes then how can we build dynamic CDT value in IDP for document extraction of different extracted PDF.
I Have line items grid in the pdf document that continues from first page to second, but IDP is extracting only from first page, the second page line items are not getting extracted. What should be done in order to get this right?
Trying to map entries that full under the same month together and return count for total entries in that month with( local!metrics: rule!OCSC_getNumOfTierTwoRequestsSubmitted( startDate: ri!startDate, endDate: ri!endDate, ), local!asmts: a!forEach( items: local!metrics, expression: { svc_request_id: fv!item.svc_request_id, totalServicesPerformed: fv!itemCount, date: fv!item.created_datetime, month: month(fv!item.created_datetime), year: year(fv!item.created_datetime) } ), local!mergedRows: local!asmts, /* create list of maps with sum of collective asmts done by year-month */ local!dates: a!forEach( items: local!mergedRows, expression: { month: fv!item.month, year: fv!item.year } ), local!datesDist: union(local!dates, local!dates), local!prepared: a!forEach( items: local!datesDist, expression: with( local!dateIndex: fv!item, a!map( month: fv!item.month, year: fv
Hi , I have list of arrays coming from foreach, now i want unique elements for the list of arrays. for example localvariables( local!arrays:foreach( items:{5,6,7}, expresssion:enumerate(fv!item)+1 ) local!arrays ). form this output, i want unique elements from the list of arrays. can anyone help me in this? intersection is working only for separate arrays stored in each local variable but not for arrays executed in foreach.
local!excelFormatFromFile: readexcelsheetpaging( excelDocument: ri!excelFile, sheetNumber: 0, paginginfo: a!pagingInfo(1,1), numberOfColumns: 11 ).data.values[1] Hi, How can i achieve same result using index function instead of using ".data.values[1]"
From the above pic, in the local variables bankruptcy there will be constant 4 values and in the local variable creditPublicRecord there will be some values can be null or more than 1 value. Here we have to compare the creditPublicRecord values with the bankruptcy values and check whether the the creditPublicRecord values matches the bankruptcy values and need to return the count. Can someone suggest the way to complete this. Thanks In Advance, Gousii.
Hey, I am trying to configure a Picker Custom Field but am getting the following error: "Interface Definition: Expression evaluation error at function a!pickerFieldCustom [line 290]: The function 'suggestfunction' is unavailable." Here is my code: a!pickerFieldCustom( label: "User Picker", placeholder: "--- Select Borrowers ---", labelPosition: "ABOVE", suggestFunction: a!dataSubset( startIndex: 1, batchSize: -1, data: if( local!view = "Borrower", index(local!borrowers,"borrower",{}), index(local!lenders,"lender",{}) ) ), value: if( local!view = "Borrower", local!selectedBorrowers, local!selectedLenders ), selectedLabels: if( local!view = "Borrower", local!selectedBorro
Hi all,I have a requirement to add all arrays (say array1,array2, and array3 ) and display them in 3 lines,Exmple : Country:{"India","china","USA"},State:{"Bangalore","Fujian","Texas"}Language:{"Kannada","Mandarin","English"} I used merge and joinarray functions,joinarray(merge(local!Country,local!state,local!language),"-")required op in three separate lines as below:india - bangalore - kannada china - Fujian - Mandarinusa - texas - EnglishHow this can be achieved. Any suggestions will be appreciated.
Hello, I am trying to train IDP on some documents which are like Forms. Some of the forms fields are checkboxes and I need to read (extract) which checkbox was selected. Is there a way to achieve this? Thanks,
Hi, community. I want to use "Appian IDP" with position specification. for example. I want to get the value of each colored part in the figure below.(This format is fixed and does not change.) This color "Area ■" is "Name Area". I want to get it like {name:"Nihon Taro"} I want to associate like "Area ■"="Name", "Area ■"="Post Code" and "Area ■"="Address". if "Appian IDP" can use with position specification, it is as good as solved. Can't you do something like that with an IDP? Please tell me how if you know. Regards!
Input map local!inputMap:{ a!map(pagenum: 1,fieldname: "Name", fieldValue:"Appian",docid:1), a!map(pagenum: 1,fieldname: "howold", fieldValue:15, docid:1), a!map(pagenum: 1,fieldname: "Name", fieldValue:"VB",docid:1), a!map(pagenum: 1,fieldname: "howold", fieldValue:12, docid:1), a!map(pagenum: 2,fieldname: "Name", fieldValue:"Java",docid:1), a!map(pagenum: 2,fieldname: "howold", fieldValue:25, docid:1), a!map(pagenum: 1,fieldname: "Name", fieldValue:"COBOL",docid:2), a!map(pagenum: 1,fieldname: "howold", fieldValue:45, docid:2), a!map(pagenum: 2,fieldname: "Name", fieldValue:"PL1",docid:2), a!map(pagenum: 2,fieldname: "howold", fieldValue:55, docid:2)}, Desired output map local!outputMap :{ a!map(pagenum: 1 , Name: "Appian", howold: 15, docid:1), a!map(pagenum: 1 , Name: "VB", howold: 12, docid:1), a!map(pagenum: 2 ,
Hello, i have a list of maps, how do you add new map value? and how do you update an index of repective value map? this is the rule code (but it do not work): ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ a!localVariables( local!campos: a!forEach( items: ri!map, expression: fv!item.sistema = ri!sistema ), local!indice: where(local!campos,-1), local!resultado:if( local!indice > 0, if( a!isNullOrEmpty(ri!permiso), remove(ri!map,local!indice), /*update value in list*/ a!update(ri!map,local!indice,a!map(sistema: ri!sistema,permiso:ri!permiso)) ), /*add map to list*/ a!update(ri!map,length(ri!map)+1,a!map(sistema: ri!sistema,permiso:ri!permiso)) ), local!resultado) -----------------------------------------------------------------------------------------------------------------------------------
Hi , I have a list of dictionaries with date ranges(refer below screenshot) i need validation that if i give a date and if the given date is overlapped with any of the dates(start and end date) i should get a validation. for example; start date : 05/10/2023 end date : 05/15/2023 i'm comapring the given date in this date range for each dictionary for that it is working fine but if i select date between 05/09/2023 and 05/16/2023 i should get validation that is not working,and there are many dictionaries like this. Cany anyone help me how to do this?
Hi, I want to show 'No URL' where url is not available ("") for any party. But that needs an indexing. This is for one party. If we want to do it for multiple parties, Can someone please suggest how can I do the index to get the actual result
I have a Matters dropdown and a Sub Matters dropdown that get their options from related tables. I want to make the choices in the Sub Matters dropdown dependent on the the selection in the Matters table. I know there needs to be a Query in the following expression section somewhere, however I am still trying to learn Appian and was hoping someone help me with the query and where to insert it..
Hi All, Is there any function that returns the last date of the current year Thanks in Advance
starting number is 100 & ending number is 200, I need all numbers that contains 5
Hi,In A Bar Chart, Can we display Tooltip value in for example in 1D 1H 1M 1S. Suppose we are getting data in floating 176.5439, and we need to display in 176D 13H 3M 13S. I have converted the value, but a!chartSeries says a!chartSeries accepts only Number (Floating Point) data (List of Number (Floating Point)): Array of decimal data values to display in a chart.
I need to get the admin group in an specific app where the app name is going to be a rule input. Any suggestion? is there anyway to achive it?
Hi All, To display wait time which is waiting for more than a day. We are converting createdDate(date time format) in days and hours. Now, ask is to display the WAIT TIME only when it is more than 1D 0H.But, queryFilter field is createdDate(date time format). In that case how can we display this.Query Filter which I'm using at present (I know it's not correct), could anyone help me in getting this expression correct.
Hi , I am getting below error the attached code when there I don't pass value for ri!gLLs. Can someone please help in resolving this. "Expression evaluation error at function 'remove' [line 67]: Invalid index (0) for list: valid range is empty" a!localVariables( /* Appending logged in user with GLLS from LUContacts if logged in user is GLL */ local!isLoggedInUserGLL: rule!APN_distinct( if( rule!APN_isEmpty(ri!gLLs), {}, if( and( not( contains( touniformstring( index( a!groupMembers( group: cons!RGRACSLBL_GROUP_AGLL, direct: true(), memberType: "USER" ), "data", {} ) ), touniformstring(ri!loggedInUser) ) ), or( contains( touniformstring(
Hello, How can we get value after an operator for the value which we separate using split function. Eg. 249.5832 Using Split for 249.5832, we can get 249 and 5832. But, I want value after split. If I index with 2, it's getting 5832, but I have to use this for a!forEach for the below expression. For below expression, getting the result as in the image local!calP1days: a!forEach( items: local!P1, expression: if( a!isNotNullOrEmpty(fv!item), split(fv!item,"."),{} ) ) , local!calP1days)
Hi, I have a requirement to update a date based on a condition that if the given date is of last 2 dates of that particular month, then I want my rule to return first date of the next month and it should be applicable for all the dates whether the month has 30 or 31 days or if it is February or leap year. For eg: 27/02/2023 should be converted to 01/03/2023. I have written following code for this, but my senior asks me to optimize the code and reduce the use of if conditions. Please tell me what else I can do edit:a!localVariables( local!currentMonth: month(ri!requestDate), local!currentDay: day(ri!requestDate), local!currentYear: year(ri!requestDate), local!isLeapYear: isleapyear(local!currentYear), todate( if( and( tointeger(local!currentMonth) = 2, or(local!isLeapYear), contains( tointeger({ 28, 29 }), tointeger(local!currentDay) ) ), concat( tointeger(local!currentMonth) + 1, "/
I am trying to perform related action for a record but I am facing below issue This issue happens for only particular record where as for other records it is working fine. Any help on this would be appreciated
Hi I am able to extract the document from fillable field in pdf by following the tutorial in forum. I tried to select handwritten notes by holding shift button and select the word but it didn't work for me. Please guide me to get the tutorial available for handwritten notes. Also is there anything which i have to take care for handwritten notes different than the fillable pdf. 1. I tried to select the work by holding the shift button 2. Preferred vendor - Appian Please guide. Thanks in advance
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.