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

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.

Developer

Developer Tools

Accepted answers

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 😀

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

Try this interface tool.

Example is attached.

Hope this helps 🙂

File_Browse.yxwz

All comments

@areeba — Can you attach sample data for input and desired output, both?

See the attached. I believe this is close to what you are asking.

Split the date from the rest of the data, then build the output file name as a string.

Hope this helps. If it does, please mark as solved.

Thanks,

Phil

Bulild Output string from Header.yxmd

Please see attached example_file that also has sample data.

I need to fetch first value of column date_delivered and suffix it the file output file name.

So the output file name should be like example_file_1-1-2020 in this case.

Example_File.xlsx

Here is a workflow for the task.

Input:

Set below option in input tool to get filename

Output:

Created file name based on first value

Workflow

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 for your reply. Yes , it matched my requirements but not 100%.

Please see this above screenshot this is my workflow and as you can see my output file name is different than my input file. My input file has that column (c029) whose first row value (2020-06-30) needs to be attached/concatenate with my output file name i.e. My output file name should appear like this 'New_cpa_Adjustment_2020-06-30.xlsx'. I am able to fetch this column c029 before Summarize tool , after this I am stuck to proceed. can you help ?

Since I am new to Alteryx ,my apologies that I couldn't make you understand clearly.

Thanx

Areeba

With few modifications provided solution will work for requirement.

Give me some sample data about 5 rows should do and the workflow i can modify it for you 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703