I have got a requirement in which I need to append(add suffix) output file name with first value of a column in input file.
My input file has date_column. I need to add the first row value of this column to the output file(excel) as suffix.
Please suggest.
Solved! Go to Solution.
Hi @areeba
Untick the highlighted option in output Tool
That should work.
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀
Hi @atcodedog05 ,
I wanted to know 2 things
First, if there is a solution to this in which I can pass my values like this first row of C029(2020-06-30) as parameterized value during run time to the output name.
Can you please help me with the solution in that workflow which i gave you sample data for.
Thanks
Areeba
Hi @areeba
sorry for the delay i didnt the notification.
Here is what you can do. I have converted the workflow to app.
Drop down is taking column names from the app.
Action tool is selected to updated the selected column.
App preview:
Based on the selection column is selected.
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind😀👍
Hi @atcodedog05
Thank you it really helped.
Can you please suggest me to the situation: I do not want to hard code the input file name, input file directory as well as output file name/directory name, like i did here in my solution using formula tool 'New_CPA_Adjustment'...is it way I can pass these values during runtime.
Thank you
Areeba
You rock! ✌️
Hi @atcodedog05 ,
I have one excel sheet where all different input files (JUST)names are present for different workflows ,so we can ask client to fill the name of the input file and we can pick from there as every
month or quarter file name will change. For eg: In InputFiles.xlsx I have
1)Report1.txt
2) report 2.xlsx
3) Report 3.xlsx (Just the names)
Is it possible that I can pick one file from that excel sheet and make it automatically run to the workflow with its data ?
Like if my client wants to run that workflow he just simply select the name of the input file and run its workflow ?
I do not want to make my workflow as a analytic app workflow.
Can I use something like command line or something else?
Regards
Areeba