I have one combined excel file and i need to extract this file according to specific column called Title
For example : if 3 records have same title should be in the same file , if not separate them
please give me a hand
I currently have a workflow that creates separate excel files for each unique value in a column.
Do you want to take a look at it?
Please check this one:
CreateReq - Copy.zip (31.1 KB)
The input file is the CreateRequisitionBulkUiPath.xlsx
Then it will create separate excel files depending on the Requisition Segment.
The excel files are placed inside the Input folder.
Please let me know if this helps.
Thanks and regards.
@Jan_Brian_Despi thanks a lot i will try and let u know
how to change the column value to be suitable to mine ?? (RequisitionSegment)
In the If statement
And also in the assign strTempId
and where to choose my own file directory ?
It is in the arguments of Excel_Filter component
I have found it yes
I am currently using a smart phone
Please Find the Arguments tab
My required column is the last one not the first one is there any difference here ?
There is no problem.
Just replace the column name
How was it?
thanks a lot
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.