Dynamic Sorting of Amounts

Question

Hi

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

Amount - 1-30000-30000-1500-0.660.2800034004500

Amount - 2-30000-30000-2800-0.66-0.450.2800034004500

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

Amount - 1Amount - 2-30000-30000-30000-30000 -2800-1500 -0.66-0.66 -0.450.20.2340034004500450080008000

KGT · Accepted Answer

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 Answer

@Divyajyothi7 another way of doing this.