How to convert CDT list into List of Varient

Considering that a!forEach() can act on any list type (including list of CDT), i'm not sure why you would want to do this - can you explain a bit more about your use case?

1.      In my process model I have a process variable of type 

you can also suggest some other ways or shortcut to make it done

my initial feedback is that you're misusing "fv!item[1]" (etc).  Each "fv!item" will be a single instance of your CDT but your square-bracket index calls make Appian want to treat "fv!item" like an array -- which it isn't.  So you'll need to fix that before this expression will work, regardless of the data type.

How can we parse 2-D array then? . In my case the variable contains:

[id=, name=pfizer, perCost=100, quantity=2, totalCost=200],[id=, name=cipla, perCost=120, quantity=2, totalCost=240],[id=, name=beta, perCost=90, quantity=1, totalCost=90],[id=, name=pathlabs, perCost=88, quantity=4, totalCost=352],[id=, name=nlabs, perCost=30, quantity=3, totalCost=90],[id=, name=cx100, perCost=230, quantity=2, totalCost=460],[id=, name=, perCost=, quantity=, totalCost=1432]

----------------------------------------------------------------------------------------------------------

I have load this data from excel with method below and it is working fine:

      a!localVariables(
         local!excelFile:readexcelsheet(
         excelDocument:ri!docId,
         sheetNumber:0,
         startRow:5
      ).result,
      local!excelinArray:a!flatten(local!excelFile),
      local!finalOut:a!forEach(
         items: local!excelinArray.values,
         expression:'type!{urn:com:appian:types:mb}MB_Medicine__Cost_Data_fromExcel'(
         name: fv!item[1],
         perCost: fv!item[2],
         quantity: fv!item[3],
         totalCost: fv!item[4]
      )
     ),
     local!finalOut

)

-------------------------------------------------

the problem comes after this when i want to change some values

The following expression should work if your intention is to find any item where the name is "cipla" and update the "perCost" of those new entry(ies).  You will need to install whatever logic you need to determine the new "perCost" value.  If you're really out to change the value of a different field (you seem to mention two conflicting things in your original post), you would simply need to change the a!update() values.  Note: if you're not yet in 21.2, a!update() will not be available but you can simply use updateDictionary() which is available in a plug-in.

a!localVariables(
  local!dataInput: ri!oldData,
  local!finalUpdate: a!forEach(
    items: local!dataInput,
    expression: a!localVariables(
      local!checking: "cipla",
      if(
        fv!item.name = local!checking,
        
        /* for items where the name is the checked-for value, update the item to new value(s) */
        a!update(
          data: fv!item,
          index: "perCost",
          value: 333 /* update perCost value here */
        ),
        
        /* for items where the name isn't the checked value, just return the item unchanged */
        fv!item
      )
      
      /*'type!{urn:com:appian:types:mb}MB_Medicine__Cost_Data_fromExcel'(*/
        /*name: if(fv!item[1]=local!checking,"ciplex",fv!item[1]),*/
        /*perCost: fv!item[2],*/
        /*quantity: fv!item[3],*/
        /*totalCost: fv!item[4],*/
      /*)*/
    )
  ),
  local!finalUpdate
)

BTW, it's 20x easier to read code snippets if you use a Code Box (Insert --> Insert Code), as this preserves indentation and uses a monospace font and (if you select "Java" from the type dropdown) gives a little bit of syntactic highlighting.  (I have no idea why "Appian SAIL" or something similar still isn't an option there.)

akshays0003 said:

I have load this data from excel with method below and it is working fine:

I don't really know why this would be working at all - the square bracket indexes would not work at all as far as I know, unless they accidentally refer to the correct dot properties by position in this context, which I didn't know was possible (and even if it is seemingly working, I would NEVER recommend coding it this way).

Hi Mike, This works fine. But don't know why it only returns only first data from an array of 5. 

Only return this : [id=, name=pfizer, perCost=100, quantity=2, totalCost=200] everytime 

I have checked it. It was working only when I use my CDT type in expression in foreach.

I have also tried one more thing when I don't use type! in expression. It just simply returns Type:List of variant and not storing any data in the process variable. fails the process earlier than before

So, I left with no other option instead of using type! in expression and brackets with fv!item