You’re offline. This is a read only version of the page.
Announcements
Hello,
I am stuck with my flow and I wanted to ask for some help.
I have a big CSV table and I need to make smaller files from the data provided in the table. The original table contains an ID as the first element of each row, so the created files schould each contain rows with the same ID. I have successfuly overcome this challenge, but now I face a bigger problem.
My flow should be able to save only some data each row. Imagine I have an Excel table and I need only 2 of 3 colomns provided there. The main challenge is that the flow should make it dinamicly: it gets an array with all colomns to be saved as an input. So the created files contain only the colomns from the input.
To make it clear, here is what a table in Excel or CSV could look like:
So for example, when the user needs only IDs and Names from the table, they should get 3 files that look like this:
I can´t understand the way to get to the result I want. To this point all I get is this:
That is my Flow until now:
Could you recommend me some way to achieve it?
p.s. I can´t just use indexes to select coloumns the use wants, because the file could contain more than 3 coloumns and the user should be able to choose any of them. The original file could contain up to 40000 rows, so I should be carefull with loops. On a file with 40000 rows, it took 4 min for the flow to end successfully, so the results I get so far are good, but I can´t get the feature with dynamically choosing coloumns right.
Share
Report
All responses (
Answers (
538
