How to update text input tool rows from csv file using analytic app?

[csh8428]

I'm new to using analytic apps.

I have a CSV file that can have any number of values in column A((ID_Value). I have a text input tool with Column Name ID_Value that I want to have each row updated with the same values from the CSV file.

I've already spent several hours of experimentation and searching the forums, but I can't quite seem to figure out the configuration to achieve this.

Any help is appreciated!

Thanks,

Craig

[AngelosPachis]

Hi @csh8428 ,

Why does it have to be a text input tool that you are going to update with the csv file values and you don't use an Input data tool directly to read the values off of that .csv file?

[SPetrie]

Correct me if I am misinterpreting here, but I believe you are over thinking it. Instead of opening a file and updating a text input tool, simply have the workflow open the csv with an input data tool and use that first column as your ID values.

I updated the workflow to do just that. I added a select to rename the first column since the sample file didnt have a column header in it.

[csh8428]

@AngelosPachis 

It will eventually go into a SQL query and I need to be able to enclose each value in apostrophes and commas downstream before going into a dynamic input SQL

My intended workflow was going to be File input - Text Tool - Formula tool to add apostrophes to each value - Summarize tool to concatenate the ID value filed into one field to add the commas - that field then goes replaces the ID_VALUE = clause into the SQL in a dynamic input tool.

For example.

Input from file:

abcd

efgh

ijkl

Needs to go to this

'abcd','efgh','ijkl'

[SPetrie · Accepted solution]

Still totally doable. You just use a summarize after the initial csv is imported.