Pass in table name from assigned variable

Flow Classic
1

tablename
tablename1887×738 13 KB

I want to select from a table in a machine step but I want to pass the table name as a variable to the select statement (see attached image). The assignment variable name is tab_no
The tab_no variable will change each time the flow is used so I cannot hardcode the table name into the flow.
I am getting an “expected token” error. Can anyone help?

2

Hi,

image
image1059×609 34.1 KB

CHECKLIST_ & {tab_no} should be assigned to a one variable(as tablename) in Assignment step.

Then use as below:

select …

FROM IFSAPP.{tablename}

Best regards,
Milinda.

1 Like
3

Thank you for your reply. I actually just put in a separate step with Flowscript in it that takes what is being entered into the table and writes it to a Flowscript table. Then I loop through that table to display it.