topic Automation - Variable block with table type in Qlik Automate

Automation - Variable block with table type

Guillaume_B — Tue, 25 Jul 2023 08:06:04 GMT

Hello,

I have an issue to add a row in variable block with table type as below :

I tried several value without success, everytime no values are added to the variable.

item1,item2

"item1","item2"

["item1","item2"]

[["item1"],["item2"]]

[item1,item2]

[[item1],[item2]]

Do you know the how to add a row ?

Guillaume

Re: Automation - Variable block with table type

Shai_E — Tue, 25 Jul 2023 13:37:39 GMT

Hi @Guillaume_B ,

I managed to add items to it, by using the convert to list formula on the added value.

So if you are adding the value for example:

["shai"]

as is it will treat it like a string, so what i did was take the same value and put it in the convert to a list formula and it worked, each time i added an item to the table it took it as a list data type.

Please note as per the user guide a variable of type 'Table' needs to be a list of lists.

Best Regards

Re: Automation - Variable block with table type

Guillaume_B — Tue, 25 Jul 2023 13:52:04 GMT

Hi @Shai_E ,

Is there a way to rename the column/field name of the table ?

Regards,

Guillaume

Re: Automation - Variable block with table type

Shai_E — Tue, 25 Jul 2023 14:00:13 GMT

Hi @Guillaume_B ,

It seems like it takes the indexes of the 3 items in the list and turns them into the tables headers.

Just by looking at how this variable type is designed, i cannot see a way on how to change it.

Best Regards