Sorting a Field using the ID of another Field

[bmac1]

Let's say I have two similar fields: Product and Product_2.

PRODUCT	PRODUCT_2
B	B
D	D
A	A
F	F
C	C
G
H

Product has an associated #Product_ID used as the sort order [ex: A=1, B=2, C=3...]

Is there a way using sort order expression to sort Product_2 by #Product_ID, even though there is no backend relationship? Assume any value in Product_2 will be available in Product.

[Kushal_Chawda]

@bmac1  try using dual(). Try using below expression in expression sort

= dual(Product2,ProductID)

[bmac1]

Returns null

[NoahF]

Hi @bmac1 ,

you could just Map the #Product_ID onto your Product_2 as a "Sorting_ID".

Then use this Sorting_ID in your sort expression.