Skip to main content
sivasuryap0002
Known Participant
Jul 23, 2022 2:41 PM UTC
Question

Indexing to Lis of text String

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
    Jul 23, 2022 2:59 PM UTC

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

    sivasuryap0002
    Known Participant
    Jul 23, 2022 3:02 PM UTC

    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
    Jul 23, 2022 3:41 PM UTC

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

    Inspiring
    Jul 25, 2022 3:43 AM UTC

    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
    Brainy
    Jul 25, 2022 5:53 AM UTC

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