Robotic Process Automation (RPA)

Hi!

Consider the whole content of data table variable ${varParametros_EmpregadosMGS}:



When I try to copy all the column number 2 to a collection list, those blank fields from the data table are being
populated with the previous data table cell, it can be noticed below, pay attention on the repeated values, they are highly undesirable. If there is a blank cell it can´t be stored in the varLista_PlayerIDs



Following is the script snippet:

for --variable ${var_contador_i} --from 1 --to ${varLinhas_Tabela} --step 1
    getTableCell --dataTable ${varParametros_EmpregadosMGS} --column 2 --row ${var_contador_i} varTemporaria_Armazenamento_PlayerIDs=value
    if --left "${varTemporaria_Armazenamento_PlayerIDs}" --operator "Is_Null_Or_Empty" --negate
        add --collection "${varLista_PlayerIDs}" --value "${varTemporaria_Armazenamento_PlayerIDs}"
    endIf
next



------------------------------
Mauro Sérgio Lima França
------------------------------

It seems this is a defect of getTableCell command. When the cell is empty or null, the command is not setting the output value, therefore, the previous value remains in the variable ${varTemporaria_Armazenamento_PlayerIDs} . Can you open a support ticket?

In the meantime, you can either

• Handle this error by checking whether the ${varTemporaria_Armazenamento_PlayerIDs} is the same as before.
• Use the mapTableRow instead.

------------------------------
Joba Diniz
Product Manager
IBM
------------------------------

Original Message:
Sent: Thu July 01, 2021 03:29 PM
From: Mauro Sérgio Lima França
Subject: Empty cells in a data table variable X Empty cells in a list collection

Hi!

Consider the whole content of data table variable ${varParametros_EmpregadosMGS}:

When I try to copy all the column number 2 to a collection list, those blank fields from the data table are being
populated with the previous data table cell, it can be noticed below, pay attention on the repeated values, they are highly undesirable. If there is a blank cell it can´t be stored in the varLista_PlayerIDs

Following is the script snippet:

for --variable ${var_contador_i} --from 1 --to ${varLinhas_Tabela} --step 1
    getTableCell --dataTable ${varParametros_EmpregadosMGS} --column 2 --row ${var_contador_i} varTemporaria_Armazenamento_PlayerIDs=value
    if --left "${varTemporaria_Armazenamento_PlayerIDs}" --operator "Is_Null_Or_Empty" --negate
        add --collection "${varLista_PlayerIDs}" --value "${varTemporaria_Armazenamento_PlayerIDs}"
    endIf
next



------------------------------
Mauro Sérgio Lima França
------------------------------

Yeah,  mapTableRow sound more robust and elegant, I´ll try it and as soon as I finish testing it I´ll let you know.

What is the procedure to open a support ticket? (I´ve never done it before)

Cordial regards,

------------------------------
Mauro Sérgio Lima França
------------------------------

Original Message:
Sent: Fri July 02, 2021 09:07 AM
From: Joba Diniz
Subject: Empty cells in a data table variable X Empty cells in a list collection

It seems this is a defect of getTableCell command. When the cell is empty or null, the command is not setting the output value, therefore, the previous value remains in the variable ${varTemporaria_Armazenamento_PlayerIDs} . Can you open a support ticket?

In the meantime, you can either

• Handle this error by checking whether the ${varTemporaria_Armazenamento_PlayerIDs} is the same as before.
• Use the mapTableRow instead.

------------------------------
Joba Diniz
Product Manager
IBM

Original Message:
Sent: Thu July 01, 2021 03:29 PM
From: Mauro Sérgio Lima França
Subject: Empty cells in a data table variable X Empty cells in a list collection

Hi!

Consider the whole content of data table variable ${varParametros_EmpregadosMGS}:

When I try to copy all the column number 2 to a collection list, those blank fields from the data table are being
populated with the previous data table cell, it can be noticed below, pay attention on the repeated values, they are highly undesirable. If there is a blank cell it can´t be stored in the varLista_PlayerIDs

Following is the script snippet:

for --variable ${var_contador_i} --from 1 --to ${varLinhas_Tabela} --step 1
    getTableCell --dataTable ${varParametros_EmpregadosMGS} --column 2 --row ${var_contador_i} varTemporaria_Armazenamento_PlayerIDs=value
    if --left "${varTemporaria_Armazenamento_PlayerIDs}" --operator "Is_Null_Or_Empty" --negate
        add --collection "${varLista_PlayerIDs}" --value "${varTemporaria_Armazenamento_PlayerIDs}"
    endIf
next



------------------------------
Mauro Sérgio Lima França
------------------------------

Joba:

mapTableRow  worked perfectly, all the data are now stored in a collection list free of repetitions.
Waiting for the instructions to open the support ticket.

Thank you very much.
Regards,


------------------------------
Mauro Sérgio
------------------------------

Original Message:
Sent: Fri July 02, 2021 09:07 AM
From: Joba Diniz
Subject: Empty cells in a data table variable X Empty cells in a list collection

It seems this is a defect of getTableCell command. When the cell is empty or null, the command is not setting the output value, therefore, the previous value remains in the variable ${varTemporaria_Armazenamento_PlayerIDs} . Can you open a support ticket?

In the meantime, you can either

• Handle this error by checking whether the ${varTemporaria_Armazenamento_PlayerIDs} is the same as before.
• Use the mapTableRow instead.

------------------------------
Joba Diniz
Product Manager
IBM

Original Message:
Sent: Thu July 01, 2021 03:29 PM
From: Mauro Sérgio Lima França
Subject: Empty cells in a data table variable X Empty cells in a list collection

Hi!

Consider the whole content of data table variable ${varParametros_EmpregadosMGS}:

When I try to copy all the column number 2 to a collection list, those blank fields from the data table are being
populated with the previous data table cell, it can be noticed below, pay attention on the repeated values, they are highly undesirable. If there is a blank cell it can´t be stored in the varLista_PlayerIDs

Following is the script snippet:

for --variable ${var_contador_i} --from 1 --to ${varLinhas_Tabela} --step 1
    getTableCell --dataTable ${varParametros_EmpregadosMGS} --column 2 --row ${var_contador_i} varTemporaria_Armazenamento_PlayerIDs=value
    if --left "${varTemporaria_Armazenamento_PlayerIDs}" --operator "Is_Null_Or_Empty" --negate
        add --collection "${varLista_PlayerIDs}" --value "${varTemporaria_Armazenamento_PlayerIDs}"
    endIf
next



------------------------------
Mauro Sérgio Lima França
------------------------------

You can open cases here: https://www.ibm.com/mysupport/s/

------------------------------
Joba Diniz
Product Manager
IBM
------------------------------

Original Message:
Sent: Fri July 02, 2021 01:40 PM
From: Mauro Sérgio
Subject: Empty cells in a data table variable X Empty cells in a list collection

Joba:

mapTableRow  worked perfectly, all the data are now stored in a collection list free of repetitions.
Waiting for the instructions to open the support ticket.

Thank you very much.
Regards,


------------------------------
Mauro Sérgio

Original Message:
Sent: Fri July 02, 2021 09:07 AM
From: Joba Diniz
Subject: Empty cells in a data table variable X Empty cells in a list collection

It seems this is a defect of getTableCell command. When the cell is empty or null, the command is not setting the output value, therefore, the previous value remains in the variable ${varTemporaria_Armazenamento_PlayerIDs} . Can you open a support ticket?

In the meantime, you can either

• Handle this error by checking whether the ${varTemporaria_Armazenamento_PlayerIDs} is the same as before.
• Use the mapTableRow instead.

------------------------------
Joba Diniz
Product Manager
IBM

Original Message:
Sent: Thu July 01, 2021 03:29 PM
From: Mauro Sérgio Lima França
Subject: Empty cells in a data table variable X Empty cells in a list collection

Hi!

Consider the whole content of data table variable ${varParametros_EmpregadosMGS}:

When I try to copy all the column number 2 to a collection list, those blank fields from the data table are being
populated with the previous data table cell, it can be noticed below, pay attention on the repeated values, they are highly undesirable. If there is a blank cell it can´t be stored in the varLista_PlayerIDs

Following is the script snippet:

for --variable ${var_contador_i} --from 1 --to ${varLinhas_Tabela} --step 1
    getTableCell --dataTable ${varParametros_EmpregadosMGS} --column 2 --row ${var_contador_i} varTemporaria_Armazenamento_PlayerIDs=value
    if --left "${varTemporaria_Armazenamento_PlayerIDs}" --operator "Is_Null_Or_Empty" --negate
        add --collection "${varLista_PlayerIDs}" --value "${varTemporaria_Armazenamento_PlayerIDs}"
    endIf
next



------------------------------
Mauro Sérgio Lima França
------------------------------