You’re offline. This is a read only version of the page.
Hi there,
Per the attached 'Masterfile', the input data is shown as follows:
I want to split this file into separate output files based on the value in the first column as follows:
'Masterfile_Fruit'
'Masterfile_Vegetable'
What is key is that I need to remove the first column values from the output and place that value (i.e. the category name) at the end of the CSV file name, and also remove any headers.
I have attached the files for reference, I couldn't attach CSV so uploaded Excel equivalent.
Any guidance would be greatly appreciated, thanks.
Hi @David52
Your challenge look similar to the one described in this post
https://powerusers.microsoft.com/t5/Building-Flows/Split-excel-file-to-multiple-csv-files-based-on-column-value/td-p/2058431
Please confirm us if you can implement a similar approach, and once you've done it we can provide you advise to adapt it for your needs (i.e. remove column names from output files, and also remove Category values)
Thanx!
=====
Share
Report
All responses (
Answers (
14,756
