Dynamic Sorting of Amounts

[Divyajyothi7]

Hi

I have two datasets of Amounts, which needs to be matched based on Amount column

Amount - 1
-30000
-30000
-1500
-0.66
0.2
8000
3400
4500

Amount - 2
-30000
-30000
-2800
-0.66
-0.45
0.2
8000
3400
4500

Expected Output : two amounts needs to be matched, and need to be sorted based on Ascending

Amount - 1	Amount - 2
-30000	-30000
-30000	-30000
	-2800
-1500
-0.66	-0.66
	-0.45
0.2	0.2
3400	3400
4500	4500
8000	8000

[KGT · Accepted solution]

For starters, joining on Amounts is risky unless you know your data. Precision can get in the road pretty easily.

Next, what defines the difference between Row 1 and Row 2? Why do these match the corresponding row, but not Row 1 matching Row 2 etc?

You can achieve the core of what you are after with a join followed by a Union of all outputs, however to make sure you don't duplicate Row 1/2, you would require a few extra tools. Take a look at the attached to see how I've done that.

[Raj · Accepted solution]

@Divyajyothi7 another way of doing this.