Hi all I'm looking for sort a database in two groups : If the digits on the "Phone Number" column equal "9 digits" put it in one group. If the digits on the "Phone Number" column less than "9 digits" put it in other group. Main Database Name Phone Number A 545567831 234245643 4356 432134256 246 7356483 Desired result Group (1) Name Phone Number A 545567831 B 234245643 D 432134256 Group (2) Name Phone Number C 4356 E 246 F 7356483 Thanks for all.

How can I sort a database in two groups ?

Hi all

I'm looking for sort a database in two groups :

If the digits on the "Phone Number" column equal "9 digits" put it in one group.

If the digits on the "Phone Number" column less than "9 digits" put it in other group.

Main Database

Name	Phone Number
A	545567831
	234245643
	4356
	432134256
	246
	7356483

Desired result

Group (1)

Name	Phone Number
A	545567831
B	234245643
D	432134256

Group (2)

Name	Phone Number
C	4356
E	246
F	7356483

Thanks for all.

Common Use Cases

Accepted answers

atrozz

Hello. The answer is it workflow. If you need only a group, use a filter tool by 'Groups' Field. Good Luck!!!

Sort Groups.yxmd

atrozz

Hello. No, all the data its possible in the same sheet (or in distinct sheets), like this.

order 1.png

And the workflow like this:

order 2.png

If you have the data in differents files, only use Union Tool to unify the datas. If you have the data in differents sheets, apply Unión tool too. If you have the data in the same file/sheet, with my workflow your obtain the answer like the result.

If you need the groups in differents outputs (sheets, files, tables, etc), use filter tool to separate the groups, like this.

order 3.png

Regards!!!

Sort Groups.yxmd

All comments

BrandonB

You can use the Length() function in the formula tool to determine the length of a string in conjunction with an If statement to create the groups. Here is an example: