How to append(add suffix) output file name with first value of a column in input file?

[areeba]

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.

[atcodedog05 · Accepted 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 😀

[atcodedog05]

Happy to help 🙂 @areeba 

Cheers and happy analyzing 😀

[areeba]

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

[atcodedog05 · Accepted solution]

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😀👍

[areeba]

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

[atcodedog05 · Accepted solution]

Hi @areeba 

Try this interface tool.

Example is attached.

Hope this helps 🙂

[areeba]

You rock! ✌️

[atcodedog05]

Happy to help 🙂 @areeba 

Cheers and happy analyzing 😀

[areeba]

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

[atcodedog05]

Hi @areeba 

Sorry but I am not aware of any such option 😶