merged column returns value in ascending order

[VRMENDESadq]

Hi, I have two tables and I merged both. But when I merged the results return in ascending order, 

Table 1

Table 2

When I merged the colunms by the "Chave" the expected result is "911,228,843", but the result appears in ascending order:

Merged Table:

Anybody can help me to put in a original order?

Thanks.

[Anonymous · Accepted solution]

Hi,

Thanks fot watkinnc's concern about the problem and i want to offer some more information for user to refet to.

hello @VRMENDESadq ,  based on the picture you have offered,  is the data type of your result column number? you can try to change the data type of the result column to number, then combine it to the table 1.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Omid_Motamedise · Accepted solution]

after merging initially use Text.Split to split text into several text and then use list.sort to sort them and use Text.combine to convert the list to text

[Anonymous · Accepted solution]

Hi,

Thanks fot watkinnc's concern about the problem and i want to offer some more information for user to refet to.

hello @VRMENDESadq ,  based on the picture you have offered,  is the data type of your result column number? you can try to change the data type of the result column to number, then combine it to the table 1.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

What code are you using for this merge?

--Nate