Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Guillaume_B
Contributor
Contributor

Automation - Variable block with table type

Hello,

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

Guillaume_B_0-1690271990852.png

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]]

Guillaume_B_1-1690272112616.png

 

Do you know the how to add a row ?

Guillaume

 

Labels (2)
1 Solution

Accepted Solutions
Shai_E
Support
Support

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

View solution in original post

3 Replies
Shai_E
Support
Support

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

Guillaume_B
Contributor
Contributor
Author

Hi @Shai_E ,

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

Guillaume_B_0-1690293109287.png

 

Regards,

Guillaume

 

Shai_E
Support
Support

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