Create fields by uploading the excel files

Hi team,

I have scenario where I need to upload the excel documents, By using the excel data, I should get the data into my interface. example in the below format,

1.I should get the drop down to the Field type component (if i give the drop down field in the excel) 

Can you please guide me for this scenario.

  Discussion posts and replies are publicly visible

Parents
  • AFAIK when you import data from an Excel document it can only extract the current value of an individual cell, not dynamically query the type of data in a cell. Are the Excel files you want to import not predictable in their content and layout? (if they're not how will you write any logic to validate, process or store that data?)

  • But I have one issue that is when I am constructing my CDT getting the null values can you please suggest me how to remove null from the current item and should get the mapping key for that

    a!localVariables(
      local!row:readexcelimportfile(
        ri!documentId,
        0,
        1,
        5
      ),
      
      local!surveyOptionsData:
      a!forEach(
        items: local!row.result.values,
        expression: a!forEach(
          items: fv!item[4],
        expression:
        a!forEach(
          items: split(fv!item,"|"),
        expression: a!localVariables(
          local!check: 
          if(
          a!isNullOrEmpty(fv!item),
          0,
          fv!item),
        'type!{urn:com:appian:types:DSC}DSC_surveyFieldOption'(
          optionName:local!check,
         mappingKey:fv!itemCount,
          sortInfo: fv!index
        )
        )
          
        
       
    )
      ),
      ),
      local!surveyOptionsData
    
    
    )

Reply
  • But I have one issue that is when I am constructing my CDT getting the null values can you please suggest me how to remove null from the current item and should get the mapping key for that

    a!localVariables(
      local!row:readexcelimportfile(
        ri!documentId,
        0,
        1,
        5
      ),
      
      local!surveyOptionsData:
      a!forEach(
        items: local!row.result.values,
        expression: a!forEach(
          items: fv!item[4],
        expression:
        a!forEach(
          items: split(fv!item,"|"),
        expression: a!localVariables(
          local!check: 
          if(
          a!isNullOrEmpty(fv!item),
          0,
          fv!item),
        'type!{urn:com:appian:types:DSC}DSC_surveyFieldOption'(
          optionName:local!check,
         mappingKey:fv!itemCount,
          sortInfo: fv!index
        )
        )
          
        
       
    )
      ),
      ),
      local!surveyOptionsData
    
    
    )

Children
No Data