Excel splitting matter

Help
#1

Hello
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

1 Like
#2

Hi @marwan.

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?

2 Likes
#3

yes please

1 Like
#4

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.
Despi

3 Likes
Your XAML Solutions for most common issues (WIKI POST, anyone can edit)
#5

@Jan_Brian_Despi thanks a lot i will try and let u know

1 Like
#6

Sure! :slight_smile:

#7

how to change the column value to be suitable to mine ?? (RequisitionSegment)

1 Like
#8

In the If statement

2 Likes
#9

And also in the assign strTempId

1 Like
#10

and where to choose my own file directory ?

1 Like
#11

It is in the arguments of Excel_Filter component

2 Likes
#12

I have found it yes

1 Like
#13

I am currently using a smart phone :slight_smile:

Please Find the Arguments tab

2 Likes
#14

My required column is the last one not the first one is there any difference here ?

1 Like
#15

There is no problem.
Just replace the column name :slight_smile:

1 Like
#16

How was it? :slight_smile:

1 Like
#17

thanks a lot

1 Like
#18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.