Skip to Content

Columns with several data connected

Hi,

I'm new to this kind of work and probably that's why I've never come to this kind of data.

First of all, thank you for the allready several responses found on the community.

So, let's get to the point. In a new universe I've found that we have some kind of Dynamic variables, so that 2 variables contains several data connected.

The Field Value is connected to the Field Name.

As you can see I have the same Ticket Id ID but the data that I need is in rows, instead of columns, is it possible to create colums with the data on the Field name and fill the row below with the Field Value Data.

The data e correlated, Example the "Número do tubo" on the Field Name is correlated to "1" in the Field Value.

Thank you in advance.

Best regards.

sap.png (31.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Sep 14, 2017 at 06:42 PM

    Hi,

    I am not sure if I understood you correctly? But if I did, just choose a cross table take the Field Name on the header and the Field Value below. And if you like to, delete the leading header row.

    Grtz

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 23 at 04:18 PM

    Hi,

    Sorry for the long wait but I was involved on another project and this became a secondary one.

    Now again with some time for it.

    The suggestion doesn't work because it will give the data in several rows for the same ticket:

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24 at 08:20 AM

    Sorry Ayman,

    Doesn't work:

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 23 at 04:35 PM

    to correct the Cross-Table, just delete the second column with the content "FTTH - ......." and use only "Ticket ID"

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17 at 11:10 AM

    Does anybody have some new ideas to fix this? :|

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 20 at 02:32 AM
    Add comment
    10|10000 characters needed characters exceeded