Hi, Greetings ! I would like to separate the table based on row - value position. I plan to use 'filter' tool, but there no similar value to tag to each Employee. Plus, the plan is to use Record ID tool, but I don't have any idea. Initial Data : Employee No.Employee Name3751ALAN70565BLAKE70568CATHERINE70581JESSIE4512THOMASTotal Employee : 5 71336HANCHER71337LEE71426SYDNEY71441FRANK71564LEMAR71566SARAHTotal Employee : 6 Desired Output : Employee No.Employee Name3751ALAN70565BLAKE70568CATHERINE70581JESSIE4512THOMAS Employee No.Employee Name71336HANCHER71337LEE71426SYDNEY71441FRANK71564LEMAR71566SARAH Thank you in advance !

Separate Table based on Rows

Hi,

Greetings !

I would like to separate the table based on row - value position.
I plan to use 'filter' tool, but there no similar value to tag to each Employee.
Plus, the plan is to use Record ID tool, but I don't have any idea.

Initial Data :

Employee No.	Employee Name
3751	ALAN
70565	BLAKE
70568	CATHERINE
70581	JESSIE
4512	THOMAS
Total Employee : 5
71336	HANCHER
71337	LEE
71426	SYDNEY
71441	FRANK
71564	LEMAR
71566	SARAH
Total Employee : 6

Desired Output :

Employee No.	Employee Name
3751	ALAN
70565	BLAKE
70568	CATHERINE
70581	JESSIE
4512	THOMAS

Employee No.	Employee Name
71336	HANCHER
71337	LEE
71426	SYDNEY
71441	FRANK
71564	LEMAR
71566	SARAH

Thank you in advance !

Preparation

Accepted answers

ShankerV

Hi @fikrizahari

Small tweak in the last tool to remove the Total as it is not needed in the output as shared in the requirement.

Many thanks

Shanker V

binu_acs

@fikrizahari another way of writing the tables in to different sheets in the same file

Employee_130423.yxmd

All comments

ShankerV

Hi @fikrizahari

One way of doing this.

Many thanks

Shanker V

ShankerV

Hi @fikrizahari

Step 1: Input

Step 2: Record ID tool

Step 3: Filter tool

Step 4: Sample tool.

Then run the workflow to get the desired output.

Many thanks

Shanker V

fikrizahari

Hi @ShankerV ,

The number of employees for both sides not fixed to 5 or 6 employees.
It is possible to have more than 30 employees.

That is the reason, why i plan to create Record ID, maybe add some formula to differentiate upper and lower part.
( possibly use the 'Total Employee' as a benchmark )

Thank you in advance !

ShankerV

Hi @fikrizahari

The modified workflow helps to do the job dynamically.

Many thanks

Shanker V

binu_acs

@fikrizahari another way of writing the tables in to different sheets in the same file

Employee_130423.yxmd

fikrizahari

Hi @ShankerV ,

It worked !
and yes, I used 'Filter' tool instead of 'Sample' tool.

Thank you !

Hi @binu_acs ,

Great ! It another idea for me to separate the final table.
It worked as well, thank you !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703