Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Suggested Answer
  • Replies 12 replies
  • Answers 1 answer
  • Subscribers 6 subscribers
  • Views 5339 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Interface Definition: Expression evaluation error: An error occurred while executing a smart service: The custom cell positions and custom cell values arrays must have the same length. (APNX-1-4505-035)

Malleswari Talakola

Hello there,

I am receiving error "Interface Definition: Expression evaluation error: An error occurred while executing a smart service: The custom cell positions and custom cell values arrays must have the same length. (APNX-1-4505-035)" even though i have exact count on position and values which are 50 columns in count.

Any help to fix this issue??

a!exportDataStoreEntityToExcel(
              entity: cons!VW_ENTITY,
              selection: a!querySelection(
                columns: {
                  a!queryColumn(
                    field: "count"
                  ),
                  a!queryColumn(
                    field: "case_id"
                  ),
                  a!queryColumn(
                    field: "case_source"
                  ),
                  a!queryColumn(
                    field: "parent_case_id"
                  ),
                  a!queryColumn(
                    field: "master_account_number"
                  ),
                  a!queryColumn(
                    field: "fund"
                  ),
                  a!queryColumn(
                    field: "account_number"
                  ),
                  a!queryColumn(
                    field: "client_type"
                  ),
                  a!queryColumn(
                    field: "transaction_type"
                  ),
                  a!queryColumn(
                    field: "transaction_sub_type"
                  ),
                  a!queryColumn(
                    field: "reconciliationType"
                  ),
                  a!queryColumn(
                    field: "rejected_flag"
                  ),
                  a!queryColumn(
                    field: "adjustment"
                  ),
                  a!queryColumn(
                    field: "case_status"
                  ),
                  a!queryColumn(
                    field: "case_task"
                  ),
                  a!queryColumn(
                    field: "case_task_status"
                  ),
                  a!queryColumn(
                    field: "monetary"
                  ),
                  a!queryColumn(
                    field: "current_assignee"
                  ),
                  a!queryColumn(
                    field: "lt_qt_lmt"
                  ),
                  a!queryColumn(
                    field: "amount_estimated"
                  ),
                  a!queryColumn(
                    field: "amount_dollars"
                  ),
                  a!queryColumn(
                    field: "request_received_on"
                  ),
                  a!queryColumn(
                    field: "sorting_complete"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_by"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_on"
                  ),
                  a!queryColumn(
                    field: "processing_completed_by"
                  ),
                  a!queryColumn(
                    field: "processing_crew_id"
                  ),
                  a!queryColumn(
                    field: "processing_completed_on"
                  ),
                  a!queryColumn(
                    field: "nigo"
                  ),
                  a!queryColumn(
                    field: "selected_audit_count"
                  ),
                  a!queryColumn(
                    field: "audit_decisons_by"
                  ),
                  a!queryColumn(
                    field: "audit_complete"
                  ),
                  a!queryColumn(
                    field: "audit_completed_on"
                  ),
                  a!queryColumn(
                    field: "audit_return_count"
                  ),
                  a!queryColumn(
                    field: "audit_return_reasons"
                  ),
                  a!queryColumn(
                    field: "decided_by_IA"
                  ),
                  a!queryColumn(
                    field: "ia_risk_score"
                  ),
                  a!queryColumn(
                    field: "ia_reason"
                  ),
                  a!queryColumn(
                    field: "reason_for_audit"
                  ),
                  a!queryColumn(
                    field: "approval_decisons_by"
                  ),
                  a!queryColumn(
                    field: "approval_complete"
                  ),
                  a!queryColumn(
                    field: "approval_return_count"
                  ),
                  a!queryColumn(
                    field: "approval_return_reasons"
                  ),
                  a!queryColumn(
                    field: "cycle_time"
                  ),
                  a!queryColumn(
                    field: "sorting_time"
                  ),
                  a!queryColumn(
                    field: "preprocessing_time"
                  ),
                  a!queryColumn(
                    field: "processing_time"
                  ),
                  a!queryColumn(
                    field: "audit_time"
                  ),
                  a!queryColumn(
                    field: "approval_time"
                  ),
                  a!queryColumn(
                    field: "correction_review_time"
                  )
                }
              ),
              startingCell: "A2",
              customCellPositions: {"A1","B1","C1","D1","E1","F1","G1","H1","I1","J1","K1","L1","M1","N1","O1","P1","Q1","R1","S1","T1",
              "U1","V1","W1","X1","Y1","Z1","AA1","AB1","AC1","AD1","AE1","AF1","AG1","AH1","AI1","AJ1","AK1","AL1","AM1","AN1","AO1","AP1",
              "AQ1","AR1","AS1","AT1","AU1","AV1","AW1","AX1"},
              customCellValues: {
                local!qwrExportData.count,
                local!qwrExportData.case_id,
                local!qwrExportData.case_source,
                if(
                  isnull(
                    local!qwrExportData.parent_case_id
                  ),
                  local!qwrExportData.case_id,
                  local!qwrExportData.parent_case_id
                ),
                local!qwrExportData.master_account_number,
                local!qwrExportData.fund,
                local!qwrExportData.account_number,
                local!qwrExportData.client_type,
                local!qwrExportData.transaction_type,
                local!qwrExportData.transaction_sub_type,
                local!qwrExportData.reconciliationType,
                local!qwrExportData.rejected_flag,
                local!qwrExportData.adjustment,
                local!qwrExportData.case_status,
                local!qwrExportData.case_task,
                local!qwrExportData.case_task_status,
                local!qwrExportData.monetary,
                local!qwrExportData.current_assignee,
                local!qwrExportData.lt_qt_lmt,
                local!qwrExportData.amount_estimated,
                local!qwrExportData.amount_dollars,
                local!qwrExportData.request_received_on,
                local!qwrExportData.sorting_complete,
                local!qwrExportData.sorting_completed_by,
                local!qwrExportData.sorting_completed_on,
                local!qwrExportData.processing_completed_by,
                local!qwrExportData.processing_crew_id,
                local!qwrExportData.processing_completed_on,
                local!qwrExportData.nigo,
                local!qwrExportData.selected_audit_count,
                local!qwrExportData.audit_decisons_by,
                local!qwrExportData.audit_complete,
                local!qwrExportData.audit_completed_on,
                local!qwrExportData.audit_return_count,
                local!qwrExportData.audit_return_reasons,
                local!qwrExportData.decided_by_IA,
                local!qwrExportData.ia_risk_score,
                local!qwrExportData.ia_reason,
                local!qwrExportData.reason_for_audit,
                local!qwrExportData.approval_decisons_by,
                local!qwrExportData.approval_complete,
                local!qwrExportData.approval_return_count,
                local!qwrExportData.approval_return_reasons,
                local!qwrExportData.cycle_time,
                local!qwrExportData.sorting_time,
                local!qwrExportData.preprocessing_time,
                local!qwrExportData.processing_time,
                local!qwrExportData.audit_time,
                local!qwrExportData.approval_time,
                local!qwrExportData.correction_review_time
              }
              )

  Discussion posts and replies are publicly visible

Parents
  • 0

    As a quick test, have you tried removing your startingCell input, since you are defining customCellPositions anyway?

  • 0 in reply to Malleswari Talakola

    Another idea might be to ensure null values are not creating funky behavior in in customCellValues by reducing the value count, to test I would comment out your local variables there and try:

    a!forEach(
  items: enumerate(50),
  expression: "test"
)

    If this works, check/replace each line for null values with blank "".

    Additionally, if any of the local values are multiple, this could cause issues by raising the count of values.

    Otherwise, we have seen issues with exporting over 50 columns in some situations, but your message is not related to this - still could cut the list by 1 to see if 49 shows the same issues, if this is not due to nulls.

  • 0 in reply to Chris

    I tried to add the null check in various formats - no luck .Tried to reduce the columns count as well - no luck.

    Not sure if am doing anything wrong.

     

    a!exportDataStoreEntityToExcel(
              entity: cons!FAS_DSE_VW_QUALITY_WORK_EXPORT,
              selection: a!querySelection(
                columns: {
                  a!queryColumn(
                    field: "count"
                  ),
                  a!queryColumn(
                    field: "case_id"
                  ),
                  a!queryColumn(
                    field: "case_source"
                  ),
                  a!queryColumn(
                    field: "parent_case_id"
                  ),
                  a!queryColumn(
                    field: "master_account_number"
                  ),
                  a!queryColumn(
                    field: "fund"
                  ),
                  a!queryColumn(
                    field: "account_number"
                  ),
                  a!queryColumn(
                    field: "client_type"
                  ),
                  a!queryColumn(
                    field: "transaction_type"
                  ),
                  a!queryColumn(
                    field: "transaction_sub_type"
                  ),
                  a!queryColumn(
                    field: "reconciliationType"
                  ),
                  a!queryColumn(
                    field: "rejected_flag"
                  ),
                  a!queryColumn(
                    field: "adjustment"
                  ),
                  a!queryColumn(
                    field: "case_status"
                  ),
                  a!queryColumn(
                    field: "case_task"
                  ),
                  a!queryColumn(
                    field: "case_task_status"
                  ),
                  a!queryColumn(
                    field: "monetary"
                  ),
                  a!queryColumn(
                    field: "current_assignee"
                  ),
                  a!queryColumn(
                    field: "lt_qt_lmt"
                  ),
                  a!queryColumn(
                    field: "amount_estimated"
                  ),
                  a!queryColumn(
                    field: "amount_dollars"
                  ),
                  a!queryColumn(
                    field: "request_received_on"
                  ),
                  a!queryColumn(
                    field: "sorting_complete"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_by"
                  ),
                  a!queryColumn(
                    field: "sorting_completed_on"
                  ),
                  a!queryColumn(
                    field: "processing_completed_by"
                  ),
                  a!queryColumn(
                    field: "processing_crew_id"
                  ),
                  a!queryColumn(
                    field: "processing_completed_on"
                  ),
                  a!queryColumn(
                    field: "nigo"
                  ),
                  a!queryColumn(
                    field: "selected_audit_count"
                  ),
                  a!queryColumn(
                    field: "audit_decisons_by"
                  ),
                  a!queryColumn(
                    field: "audit_complete"
                  ),
                  a!queryColumn(
                    field: "audit_completed_on"
                  ),
                  a!queryColumn(
                    field: "audit_return_count"
                  ),
                  a!queryColumn(
                    field: "audit_return_reasons"
                  ),
                  a!queryColumn(
                    field: "decided_by_IA"
                  ),
                  a!queryColumn(
                    field: "ia_risk_score"
                  ),
                  a!queryColumn(
                    field: "ia_reason"
                  ),
                  a!queryColumn(
                    field: "reason_for_audit"
                  ),
                  a!queryColumn(
                    field: "approval_decisons_by"
                  ),
                  a!queryColumn(
                    field: "approval_complete"
                  ),
                  a!queryColumn(
                    field: "approval_return_count"
                  ),
                  a!queryColumn(
                    field: "approval_return_reasons"
                  ),
                  a!queryColumn(
                    field: "cycle_time"
                  ),
                  a!queryColumn(
                    field: "sorting_time"
                  ),
                  a!queryColumn(
                    field: "preprocessing_time"
                  ),
                  a!queryColumn(
                    field: "processing_time"
                  ),
                  a!queryColumn(
                    field: "audit_time"
                  ),
                  a!queryColumn(
                    field: "approval_time"
                  ),
                  a!queryColumn(
                    field: "correction_review_time"
                  )
                }
              ),
              filters: a!queryLogicalExpression(
                operator: "AND",
                filters: { 
                  a!queryFilter(
                    field: if(
                      ri!filter = 1,
                      "processing_completed_on",
                      ri!filter = 2,
                      "request_received_on",
                      "audit_completed_on"
                    ),
                    operator: ">=",
                    value: todatetime(ri!startDate)
                  ),
                  a!queryFilter(
                    field: if(
                      ri!filter = 1,
                      "processing_completed_on",
                      ri!filter = 2,
                      "request_received_on",
                      "audit_completed_on"
                    ),
                    operator: "<=",
                    value: todatetime(ri!endDate)
                  ),
                  if(
                    ri!caseFilter = 4, 
                    a!queryFilter(
                      field: "transaction_type_ref_id",
                      operator: "in",
                      value: tointeger(a!flatten(ri!monetaryOnly))
                    ),
                    if(
                      ri!caseFilter = 5, 
                      a!queryFilter(
                        field: "transaction_type_ref_id",
                        operator: "in",
                        value: tointeger(a!flatten(ri!clericalOnly))
                      ),
                      if(
                        ri!caseFilter = 6, 
                        a!queryFilter(
                          field: "transaction_type_ref_id",
                          operator: "in",
                          value: tointeger(a!flatten({ri!clericalOnly, ri!monetaryOnly}))
                        ),
                        {}
                      )
                    )
                  ),
                  if(
                    ri!caseFilter = 7,
                    a!queryFilter(
                      field: "transaction_type_ref_id",
                      operator: "in",
                      value: tointeger(a!flatten(ri!onboardingOrContracts))
                    ),
                    /*Added this below logic to include all OS-OPS & IS-OPS data to be retrieved as part of the export*/
                    if(
                      ri!caseFilter = 1,
                      concat(
                        a!queryFilter(
                          field: "transaction_type_ref_id",
                          operator: "not in",
                          value: tointeger(a!flatten(ri!onboardingOrContracts))
                        ),
                        a!queryFilter(
                          field: "transaction_type_ref_id",
                          operator: "in",
                          value: tointeger(
                            a!flatten(
                              {
                                ri!clericalOnly,
                                ri!monetaryOnly,
                                ri!correspondenceOnly
                              }
                            )
                          )
                        )
                      ),
                      a!queryFilter(
                        field: "transaction_type_ref_id",
                        operator: "not in",
                        value: tointeger(a!flatten(ri!onboardingOrContracts))
                      )
                    )
                  ),
                  if(
                    ri!caseFilter = 6,
                    a!queryFilter(
                      field: "selected_audit_count",
                      operator: ">=",
                      value: 1
                    ),
                    {}
                  )
                },
                /*correspondence*/
                logicalexpressions:  if(
                  ri!caseFilter = 3,
                  a!queryLogicalExpression(
                    operator: "OR",
                    filters: 
                    {
                      a!queryFilter(
                        field: "transaction_type_ref_id",
                        operator: "in",
                        value: tointeger(a!flatten(ri!correspondenceOnly))
                      ),
                      a!queryFilter(
                        field: "rejected_flag",
                        operator: "=",
                        value: "Y"
                      ),
                    },

                  ),
                  {}
                ),
                ignoreFiltersWithEmptyValues: false
              ),
              documentName: if(
                ri!caseFilter = 7,
                "IS-OPS Quality Work Export " & now(),
                ri!caseFilter = 2,
                "OS-OPS Quality Work Export " & now(),
                "OS-OPS & IS-OPS Quality Work Export " & now(),
              ),
              startingCell: "A2",
              customCellPositions: {"A1","B1","C1","D1","E1","F1","G1","H1","I1","J1","K1","L1","M1","N1","O1","P1","Q1","R1","S1","T1",
              "U1","V1","W1","X1","Y1","Z1","AA1","AB1","AC1","AD1","AE1","AF1","AG1","AH1","AI1","AJ1","AK1","AL1","AM1","AN1","AO1","AP1",
              "AQ1","AR1","AS1","AT1","AU1","AV1","AW1","AX1"},
              customCellValues:
              {
                rule!MS_isBlank(local!qwrExportData.count),
                rule!MS_isBlank(local!qwrExportData.case_id),
                rule!MS_isBlank(local!qwrExportData.case_source),
                if(
                  rule!MS_isBlank(local!qwrExportData.parent_case_id),
                  local!qwrExportData.case_id,
                  local!qwrExportData.parent_case_id),
                  rule!MS_isBlank(local!qwrExportData.master_account_number),
                  rule!MS_isBlank(local!qwrExportData.fund),
                  rule!MS_isBlank(local!qwrExportData.account_number),
                  rule!MS_isBlank(local!qwrExportData.client_type),
                  rule!MS_isBlank(local!qwrExportData.transaction_type),
                  rule!MS_isBlank(local!qwrExportData.transaction_sub_type),
                  rule!MS_isBlank(local!qwrExportData.reconciliationType),
                  rule!MS_isBlank(local!qwrExportData.rejected_flag),
                  rule!MS_isBlank(local!qwrExportData.adjustment),
                  rule!MS_isBlank(local!qwrExportData.case_status),
                  rule!MS_isBlank(local!qwrExportData.case_task),
                  rule!MS_isBlank(local!qwrExportData.case_task_status),
                  rule!MS_isBlank(local!qwrExportData.monetary),
                  rule!MS_isBlank(local!qwrExportData.current_assignee),
                  rule!MS_isBlank(local!qwrExportData.lt_qt_lmt),
                  rule!MS_isBlank(local!qwrExportData.amount_estimated),
                  rule!MS_isBlank(local!qwrExportData.amount_dollars),
                  rule!MS_isBlank(local!qwrExportData.request_received_on),
                  rule!MS_isBlank(local!qwrExportData.sorting_complete),
                  rule!MS_isBlank(local!qwrExportData.sorting_completed_by),
                  rule!MS_isBlank(local!qwrExportData.sorting_completed_on),
                  rule!MS_isBlank(local!qwrExportData.processing_completed_by),
                  rule!MS_isBlank(local!qwrExportData.processing_crew_id),
                  rule!MS_isBlank(local!qwrExportData.processing_completed_on),
                  rule!MS_isBlank(local!qwrExportData.nigo),
                  rule!MS_isBlank(local!qwrExportData.selected_audit_count),
                  rule!MS_isBlank(local!qwrExportData.audit_decisons_by),
                  rule!MS_isBlank(local!qwrExportData.audit_complete),
                  rule!MS_isBlank(local!qwrExportData.audit_completed_on),
                  rule!MS_isBlank(local!qwrExportData.audit_return_count),
                  rule!MS_isBlank(local!qwrExportData.audit_return_reasons),
                  rule!MS_isBlank(local!qwrExportData.decided_by_IA),
                  rule!MS_isBlank(local!qwrExportData.ia_risk_score),
                  rule!MS_isBlank(local!qwrExportData.ia_reason),
                  rule!MS_isBlank(local!qwrExportData.reason_for_audit),
                  rule!MS_isBlank(local!qwrExportData.approval_decisons_by),
                  rule!MS_isBlank(local!qwrExportData.approval_complete),
                  rule!MS_isBlank(local!qwrExportData.approval_return_count),
                  rule!MS_isBlank(local!qwrExportData.approval_return_reasons),
                  rule!MS_isBlank(local!qwrExportData.cycle_time),
                  rule!MS_isBlank(local!qwrExportData.sorting_time),
                  rule!MS_isBlank(local!qwrExportData.preprocessing_time),
                  rule!MS_isBlank(local!qwrExportData.processing_time),
                  rule!MS_isBlank(local!qwrExportData.audit_time),
                  rule!MS_isBlank(local!qwrExportData.approval_time),
                  rule!MS_isBlank(local!qwrExportData.correction_review_time)
                  },
              saveInFolder: cons!FAS_ADHOC_REPORTS_FOLDER,
              onSuccess: a!save(local!exportDocId, fv!newDocument),
              /*This displays an error if there is an issue executing the the save*/
              onError: a!save(
                local!errorMessage,
                "Error Exporting File to CSV" 
              )
            ),
    {
                if(isnull(index(local!qwrExportData,"count","")), "", index(local!qwrExportData,"count","")),
                if(isnull(index(local!qwrExportData,"case_id","")), "", index(local!qwrExportData,"case_id","")),
                if(isnull(index(local!qwrExportData,"case_source","")), "",index(local!qwrExportData,"case_source","")),
                if(
                  isnull(
                    index(local!qwrExportData,"parent_case_id","")
                  ),
                  index(local!qwrExportData,"case_id",""),
                  index(local!qwrExportData,"parent_case_id",""),
                ),
                if(isnull(index(local!qwrExportData,"master_account_number","")), "", index(local!qwrExportData,"master_account_number","")),
                if(isnull(index(local!qwrExportData,"fund","")), "", index(local!qwrExportData,"fund","")),
                if(isnull(index(local!qwrExportData,"account_number","")), "", index(local!qwrExportData,"account_number","")),
                if(isnull(index(local!qwrExportData,"client_type","")), "",index(local!qwrExportData,"client_type","")),
                if(isnull(index(local!qwrExportData,"transaction_type","")), "",index(local!qwrExportData,"transaction_type","")),
                if(isnull(index(local!qwrExportData,"transaction_sub_type","")), "",index(local!qwrExportData,"transaction_sub_type","")),
                if(isnull(index(local!qwrExportData,"reconciliationType","")), "", index(local!qwrExportData,"reconciliationType","")),
                if(isnull(index(local!qwrExportData,"rejected_flag","")), "", index(local!qwrExportData,"rejected_flag","")),
                if(isnull(index(local!qwrExportData,"adjustment","")), "", index(local!qwrExportData,"adjustment","")),
                if(isnull(index(local!qwrExportData,"case_status","")), "", index(local!qwrExportData,"case_status","")),
                if(isnull(index(local!qwrExportData,"case_task","")), "", index(local!qwrExportData,"case_task","")),
                if(isnull(index(local!qwrExportData,"case_task_status","")), "", index(local!qwrExportData,"case_task_status","")),
                if(isnull(index(local!qwrExportData,"monetary","")), "", index(local!qwrExportData,"monetary","")),
                if(isnull(index(local!qwrExportData,"current_assignee","")), "", index(local!qwrExportData,"current_assignee","")),
                if(isnull(index(local!qwrExportData,"lt_qt_lmt","")), "", index(local!qwrExportData,"lt_qt_lmt","")),
                if(isnull(index(local!qwrExportData,"amount_estimated","")), "",index(local!qwrExportData,"amount_estimated","")),
                if(isnull(index(local!qwrExportData,"amount_dollars","")), "",index(local!qwrExportData,"amount_dollars","")),
                if(isnull(index(local!qwrExportData,"request_received_on","")), "", index(local!qwrExportData,"request_received_on","")),
                if(isnull(index(local!qwrExportData,"sorting_complete","")), "",index(local!qwrExportData,"sorting_complete","")),
                if(isnull(index(local!qwrExportData,"sorting_completed_by","")), "",index(local!qwrExportData,"sorting_completed_by","")),
                if(isnull(index(local!qwrExportData,"sorting_completed_on","")), "", index(local!qwrExportData,"sorting_completed_on","")),
                if(isnull(index(local!qwrExportData,"processing_completed_by","")), "", index(local!qwrExportData,"processing_completed_by","")),
                if(isnull(index(local!qwrExportData,"processing_crew_id","")), "", index(local!qwrExportData,"processing_crew_id","")),
                if(isnull(index(local!qwrExportData,"processing_completed_on","")), "", index(local!qwrExportData,"processing_completed_on","")),
                if(isnull(index(local!qwrExportData,"nigo","")), "",index(local!qwrExportData,"nigo","")),
                if(isnull(index(local!qwrExportData,"selected_audit_count","")), "",index(local!qwrExportData,"selected_audit_count","")),
                if(isnull(index(local!qwrExportData,"audit_decisons_by","")), "", index(local!qwrExportData,"audit_decisons_by","")),
                if(isnull(index(local!qwrExportData,"audit_complete","")), "", index(local!qwrExportData,"audit_complete","")),
                if(isnull(index(local!qwrExportData,"audit_completed_on","")), "", index(local!qwrExportData,"audit_completed_on","")),
                if(isnull(index(local!qwrExportData,"audit_return_count","")), "", index(local!qwrExportData,"audit_return_count","")),
                if(isnull(index(local!qwrExportData,"audit_return_reasons","")), "",index(local!qwrExportData,"audit_return_reasons","")),
                if(isnull(index(local!qwrExportData,"decided_by_IA","")), "", index(local!qwrExportData,"decided_by_IA","")),
                if(isnull(index(local!qwrExportData,"ia_risk_score","")), "", index(local!qwrExportData,"ia_risk_score","")),
                if(isnull(index(local!qwrExportData,"ia_reason","")), "", index(local!qwrExportData,"ia_reason","")),
                if(isnull(index(local!qwrExportData,"reason_for_audit","")), "", index(local!qwrExportData,"reason_for_audit","")),
                if(isnull(index(local!qwrExportData,"approval_decisons_by","")), "",index(local!qwrExportData,"approval_decisons_by","")),
                if(isnull(index(local!qwrExportData,"approval_complete","")), "",index(local!qwrExportData,"approval_complete","")),
                if(isnull(index(local!qwrExportData,"approval_return_count","")), "", index(local!qwrExportData,"approval_return_count","")),
                if(isnull(index(local!qwrExportData,"approval_return_reasons","")), "",index(local!qwrExportData,"approval_return_reasons","")),
                if(isnull(index(local!qwrExportData,"cycle_time","")), "",index(local!qwrExportData,"cycle_time","")),
                if(isnull(index(local!qwrExportData,"sorting_time","")), "",index(local!qwrExportData,"sorting_time","")),
                if(isnull(index(local!qwrExportData,"preprocessing_time","")), "",index(local!qwrExportData,"preprocessing_time","")),
                if(isnull(index(local!qwrExportData,"processing_time","")), "",index(local!qwrExportData,"processing_time","")),
                if(isnull(index(local!qwrExportData,"audit_time","")), "",index(local!qwrExportData,"audit_time","")),
                if(isnull(index(local!qwrExportData,"approval_time","")), "",index(local!qwrExportData,"approval_time","")),
                if(isnull(index(local!qwrExportData,"correction_review_time","")),"",index(local!qwrExportData,"correction_review_time",""))
              },

  • 0 in reply to Chris

    above foreach is working fine and it is not an issue

  • 0 in reply to Malleswari Talakola

    Interesting - can you reduce it down to 1 cell only to try and get it working in the simplest format?

    The a!forEach() produces a list of 50 values, so when that is working it is telling me that the list of customCellValues is returning a different value than 50.  Sometimes this can be due to nested lists, etc, but it should not be a complex solution once we can pinpoint the issue.

    I would also be interested in what value is returned if you comment the current expression out and test a count() on the values such as:

    count(
  {
    if(isnull(property(local!qwrExportData,"count","")), "", property(local!qwrExportData,"count","")),
    if(isnull(property(local!qwrExportData,"case_id","")), "", property(local!qwrExportData,"case_id","")),
    if(isnull(property(local!qwrExportData,"case_source","")), "",property(local!qwrExportData,"case_source","")),
    if(
      isnull(
        property(local!qwrExportData,"parent_case_id","")
      ),
      property(local!qwrExportData,"case_id",""),
      property(local!qwrExportData,"parent_case_id",""),
    ),
    if(isnull(property(local!qwrExportData,"master_account_number","")), "", property(local!qwrExportData,"master_account_number","")),
    if(isnull(property(local!qwrExportData,"fund","")), "", property(local!qwrExportData,"fund","")),
    if(isnull(property(local!qwrExportData,"account_number","")), "", property(local!qwrExportData,"account_number","")),
    if(isnull(property(local!qwrExportData,"client_type","")), "",property(local!qwrExportData,"client_type","")),
    if(isnull(property(local!qwrExportData,"transaction_type","")), "",property(local!qwrExportData,"transaction_type","")),
    if(isnull(property(local!qwrExportData,"transaction_sub_type","")), "",property(local!qwrExportData,"transaction_sub_type","")),
    if(isnull(property(local!qwrExportData,"reconciliationType","")), "", property(local!qwrExportData,"reconciliationType","")),
    if(isnull(property(local!qwrExportData,"rejected_flag","")), "", property(local!qwrExportData,"rejected_flag","")),
    if(isnull(property(local!qwrExportData,"adjustment","")), "", property(local!qwrExportData,"adjustment","")),
    if(isnull(property(local!qwrExportData,"case_status","")), "", property(local!qwrExportData,"case_status","")),
    if(isnull(property(local!qwrExportData,"case_task","")), "", property(local!qwrExportData,"case_task","")),
    if(isnull(property(local!qwrExportData,"case_task_status","")), "", property(local!qwrExportData,"case_task_status","")),
    if(isnull(property(local!qwrExportData,"monetary","")), "", property(local!qwrExportData,"monetary","")),
    if(isnull(property(local!qwrExportData,"current_assignee","")), "", property(local!qwrExportData,"current_assignee","")),
    if(isnull(property(local!qwrExportData,"lt_qt_lmt","")), "", property(local!qwrExportData,"lt_qt_lmt","")),
    if(isnull(property(local!qwrExportData,"amount_estimated","")), "",property(local!qwrExportData,"amount_estimated","")),
    if(isnull(property(local!qwrExportData,"amount_dollars","")), "",property(local!qwrExportData,"amount_dollars","")),
    if(isnull(property(local!qwrExportData,"request_received_on","")), "", property(local!qwrExportData,"request_received_on","")),
    if(isnull(property(local!qwrExportData,"sorting_complete","")), "",property(local!qwrExportData,"sorting_complete","")),
    if(isnull(property(local!qwrExportData,"sorting_completed_by","")), "",property(local!qwrExportData,"sorting_completed_by","")),
    if(isnull(property(local!qwrExportData,"sorting_completed_on","")), "", property(local!qwrExportData,"sorting_completed_on","")),
    if(isnull(property(local!qwrExportData,"processing_completed_by","")), "", property(local!qwrExportData,"processing_completed_by","")),
    if(isnull(property(local!qwrExportData,"processing_crew_id","")), "", property(local!qwrExportData,"processing_crew_id","")),
    if(isnull(property(local!qwrExportData,"processing_completed_on","")), "", property(local!qwrExportData,"processing_completed_on","")),
    if(isnull(property(local!qwrExportData,"nigo","")), "",property(local!qwrExportData,"nigo","")),
    if(isnull(property(local!qwrExportData,"selected_audit_count","")), "",property(local!qwrExportData,"selected_audit_count","")),
    if(isnull(property(local!qwrExportData,"audit_decisons_by","")), "", property(local!qwrExportData,"audit_decisons_by","")),
    if(isnull(property(local!qwrExportData,"audit_complete","")), "", property(local!qwrExportData,"audit_complete","")),
    if(isnull(property(local!qwrExportData,"audit_completed_on","")), "", property(local!qwrExportData,"audit_completed_on","")),
    if(isnull(property(local!qwrExportData,"audit_return_count","")), "", property(local!qwrExportData,"audit_return_count","")),
    if(isnull(property(local!qwrExportData,"audit_return_reasons","")), "",property(local!qwrExportData,"audit_return_reasons","")),
    if(isnull(property(local!qwrExportData,"decided_by_IA","")), "", property(local!qwrExportData,"decided_by_IA","")),
    if(isnull(property(local!qwrExportData,"ia_risk_score","")), "", property(local!qwrExportData,"ia_risk_score","")),
    if(isnull(property(local!qwrExportData,"ia_reason","")), "", property(local!qwrExportData,"ia_reason","")),
    if(isnull(property(local!qwrExportData,"reason_for_audit","")), "", property(local!qwrExportData,"reason_for_audit","")),
    if(isnull(property(local!qwrExportData,"approval_decisons_by","")), "",property(local!qwrExportData,"approval_decisons_by","")),
    if(isnull(property(local!qwrExportData,"approval_complete","")), "",property(local!qwrExportData,"approval_complete","")),
    if(isnull(property(local!qwrExportData,"approval_return_count","")), "", property(local!qwrExportData,"approval_return_count","")),
    if(isnull(property(local!qwrExportData,"approval_return_reasons","")), "",property(local!qwrExportData,"approval_return_reasons","")),
    if(isnull(property(local!qwrExportData,"cycle_time","")), "",property(local!qwrExportData,"cycle_time","")),
    if(isnull(property(local!qwrExportData,"sorting_time","")), "",property(local!qwrExportData,"sorting_time","")),
    if(isnull(property(local!qwrExportData,"preprocessing_time","")), "",property(local!qwrExportData,"preprocessing_time","")),
    if(isnull(property(local!qwrExportData,"processing_time","")), "",property(local!qwrExportData,"processing_time","")),
    if(isnull(property(local!qwrExportData,"audit_time","")), "",property(local!qwrExportData,"audit_time","")),
    if(isnull(property(local!qwrExportData,"approval_time","")), "",property(local!qwrExportData,"approval_time","")),
    if(isnull(property(local!qwrExportData,"correction_review_time","")),"",property(local!qwrExportData,"correction_review_time",""))
  }
)

    Note I did swap out the index() calls for property(), they currently will work the same in this scenario but my preference is to use property() to return values based on field name, and index() when returning values based on integer position.  There is some debate on the necessity of being particular there Slight smile

  • 0
    Certified Lead Developer
     in reply to Chris
    Chris said:
    my preference is to use property() to return values based on field name, and index() when returning values based on integer position

    Heart eyes

Reply Children
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.