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