https://community.databricks.com/t5/get-started-discussions/usage-of-if-else-condition-for-data-check/m-p/65756#M6998 <P>Hi,</P><P>In a particular Workflows Job, I am trying to add some data checks in between each task by using If else statement.&nbsp;</P><P>I used following statement in a notebook to call parameter in if else condition to check logic.</P><P>{<BR />"job_id": XXXXX,<BR />"notebook_params": {<BR />"minMPID": "200912",<BR />"maxMPID": "202312",<BR />"Flag":1<BR />}<BR />}</P><P>After that, I am adding a if/else condition task in between 2 tasks to check data and calling maxMPID to check whether&nbsp;maxMPID == 202312. However, it gets failure.</P><P>How to define a parameter to use in if else condition Job? Or do you have any suggestion to add sanity checks for data (whether any duplication, or table filled) in between each task?</P> Mon, 08 Apr 2024 07:06:16 GMT Azsdc 2024-04-08T07:06:16Z https://community.databricks.com/t5/get-started-discussions/usage-of-if-else-condition-for-data-check/m-p/65756#M6998 <P>Hi,</P><P>In a particular Workflows Job, I am trying to add some data checks in between each task by using If else statement.&nbsp;</P><P>I used following statement in a notebook to call parameter in if else condition to check logic.</P><P>{<BR />"job_id": XXXXX,<BR />"notebook_params": {<BR />"minMPID": "200912",<BR />"maxMPID": "202312",<BR />"Flag":1<BR />}<BR />}</P><P>After that, I am adding a if/else condition task in between 2 tasks to check data and calling maxMPID to check whether&nbsp;maxMPID == 202312. However, it gets failure.</P><P>How to define a parameter to use in if else condition Job? Or do you have any suggestion to add sanity checks for data (whether any duplication, or table filled) in between each task?</P> Mon, 08 Apr 2024 07:06:16 GMT https://community.databricks.com/t5/get-started-discussions/usage-of-if-else-condition-for-data-check/m-p/65756#M6998 Azsdc 2024-04-08T07:06:16Z