merged column returns value in ascending order

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
1 year ago
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
1 year ago
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
Not applicable
1 year ago
What code are you using for this merge?

--Nate
Anonymous
Not applicable
1 year ago
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
Super User
1 year ago
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

Forum Discussion