Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Assign values into Grid Variables

Using python component, how can I assign a set of list/values into grid variables?

3 Community Answers

Matillion Agent  

Ian Funnell —

Hi Dhira,

You need to build a list of lists for example using a Database Query component like this:

cursor.execute("SELECT ....")
row = [[item[0]] for item in cursor.fetchall()]
context.updateGridVariable('TheGridVariable', row)

Best regards,
Ian


Dhira Dharman —

Ian,

Still not able to assign and print grid variables. Would you mind to go thru this in a call?

Please send invite to kevin.tay@warnerchappell.com, nick.lu@warnerchappell.com, afiq.ruslan@warnerchappell.com


Dhira Dharman —

It is resolved

Post Your Community Answer

To add an answer please login