Announcements
Hi i do have the following FLOW:
1. Get files (from a path)
2. read the text out of it
3. create a varibale for the specific column
4. write the column data into a txt file
The problem is i can't get the values into a variable.. why is that so?
Your variable is table so you need to give it a row which you take the value from. Now you only give it the column.If you create For each loop that uses that CSVTable variable then that syntax works %CSVTable['Column#1']%Or if you want to just use first row then: %CSVTable[0]['Column#1']%
Hi i want every value from that column stored into the file
Then do something like this:
So have another loop that uses the CSVTable and then you refer to that loops currentItem and the column.So you go through every row of the CSVTable.The idea is that then its not a dataTable any more but a data row so you can then refer to the column only and go through each row
So inside the second loop %CurrentItem['Column#1']% refers to that single data rows Column#1. Then it goes to the next row in the next loop until it has gone through them all.When you Write text to file remember to append and not over write.
I forgot about the Retrive data table column into list -action.This should actually be cleaner without an extra loop:
So if you use Retrieve data table column into list and just use that in write text to file
Thank you worked, but also like this
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 474
11manish 268
David_MA 243 Super User 2026 Season 1
