Skip to main content
sivasuryap0002
July 23, 2022
Question

Indexing to Lis of text String

  • July 23, 2022
  • 21 replies
  • 1 view

Hi All,

I am trying to use indexing for type " List of Text String " but the output i am getting not the expected output i am adding the screenshots here for reference.

Thanks In advance,

SSP

    21 replies

    stefanhelzle0001
    Brainy
    July 23, 2022

    Can you share your code? I am sure I understand what you do and what your goal is.

    sivasuryap0002
    July 23, 2022

    Hi Stefan,
    Here is my code.

    a!localVariables(
      local!exceldata: readexcelsheet(
        excelDocument: cons!IT_SAMPLE_FILE,
        sheetNumber: 0,
        startRow: 0,
        /*stopReadingAtFirstBlankRow: false(),*/
        /*pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 0)*/
        
      ),
      local!datalength: length(
        index(local!exceldata, "result", "values", {})
      ),
      local!headers: index(local!exceldata, "result", "values", 1, {}),
      local!filecdt: a!forEach(
        items: local!headers[1],
        expression: {
          fv!item & " : " & a!forEach(
            items: 2,
            /*enumerate(local!datalength - 1) + 2,*/
            expression: a!forEach(
              items: index(
                local!exceldata,
                "result",
                "values",
                fv!item,
                {}
              ),
              expression: a!forEach(
                items: fv!item,
                expression: a!forEach(
                  items: fv!item,
                  expression: fv!item
                )
              )
            )
          )
        }
      ),
      local!filecdt
    )

    stefanhelzle0001
    Brainy
    July 23, 2022

    This is confusing. Why do you use more than three parameters with the index function? The behaviour with more than three parameters is undefined.

    July 25, 2022

    Could you please put some light on the functionality what you are trying to achieve. What is the output you are getting and what you are expecting for the same?

    harshitb6843
    July 25, 2022

    Try using the a!flatten() function to remove this multiple levels of lists and then it should be easier.