How to reference the text input in the workflow?

lillyt2006

I have a text input (ABC) which I have to use as part of the output filename in Excel. (ie. Output_ABC.xlsx)

I know how to create the formula to replace the entire path for the output name.

The text input is used to filter out the rows but its not a selected field for the final output.

I create the formula towards the end of the workflow but it does not recognize the text input variable.

I also try to create the formula right after the SQL but just before I write to the output, the formula also doesnt recognize variable.

Thanks in advance

Capture.JPG

Developer

Accepted answers

All comments

PanPP

Hi @lillyt2006

Make sure the file name or file path is in a column with a value associated with it.

Can you attach your workflow or a sample workflow?

In the output tool (below) you will need to select the file path column (take file/table name from field configuration).

Output Tool.png

Hope this helps, if it does please like the post and mark it as a solution.

grazitti_sapna

@lillyt2006 , Here is a sample workflow to your query. You need to use the formula tool for this and you can suffix your excel file name with whatever name you want.

Please accept my solution if it helped and let me know if you need any help on this.

MultiFile.yxzp

lillyt2006

I apologize for being so confusing. Filepath and filename are defined as constant.

The input_date needs to be part of the filename. I dont know how to carry the input_date data into the formula that builds the filename.

In this example the input_date feeds into one datasource, but the actual workflow feeds into many different datasources.

I attach the workflow. (I had to remove the data in the dynamic input object for security reason)

Thank.

sample.yxmd

lillyt2006

Thanks for looking into my question. I dont see an text input and dynamic input in the same workflow.

The text input is to be appending to the filename.

The formula does not recognize the text input.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703