Conditional Copy

[smpa01]

I have two Lookup activity that returns following two values

//Lookup 1
{
	"firstRow": {
		"NewWatermarkvalue": "2024-07-20T00:30:13Z"
	}
}

//Lookup2
{
	"count": 1,
	"value": [
		{
			"OldWatermark": "1900-01-01T00:00:00Z"
		}
	]
}

I want to create a IF condition where new>old then do something else do nothing.

I wrote this expression

@greater(activity('Lookup2').output.firstRow.NewWatermarkvalue,activity('Lookup1').output.value[0].OldWatermark)

But it did not ingest a single row even though it evaluated for 40 min, probably because the if expression is not correct as the evaluation of if does not result to anything.

What am I doing wrong here?

Thank you in advance.

[Anonymous · Accepted solution]

Hi @smpa01 ,

In Data Factory, IF conditional expressions should use the correct JSON paths and functions to ensure that the comparison operation is correct.

Try to modify your formula like below:

@greater(activity('Lookup1').output.firstRow.NewWatermarkvalue, activity('Lookup2').output.value[0].OldWatermark)

Refer to below document:

If Condition activity - Microsoft Fabric | Microsoft Learn

Best Regards,
Adamk Kong

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