Validation

Vineet S 730

Hi, 3+2 ; select case when count(emp) = coun(dept) then pass or fall end from emp (How to validate condition and send extract to blob storage as results.. Pls share screenshot

AnnuKumari-MSFT 32,661 Reputation points Microsoft Employee

2024-08-27T05:04:03.7833333+00:00

Hi @Vineet S ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
AnnuKumari-MSFT 32,661 Reputation points Microsoft Employee

2024-08-29T05:32:05.5766667+00:00

Hi @Vineet S ,

Just checking if you have got the chance to take a look at the below answer, in case it helped, I would request you to kindly accept the answer by clicking on Accept answer button. Thankyou

1 answer

AnnuKumari-MSFT 32,661 Reputation points Microsoft Employee

2024-08-26T08:25:56.9866667+00:00

Hi @Vineet S ,

Thankyou for posting your query on Microsoft Q&A platform.

Based on your query, it seems like you are trying to validate whether the count of employees is equal to the count of departments and then send the result to blob storage.

To validate a condition and send the results to Blob Storage using Azure Data Factory (ADF), you can follow these steps:

1. Lookup Activity: Execute the SQL query: SELECT CASE WHEN COUNT(emp) = COUNT(dept) THEN 'pass' ELSE 'fall' END AS result FROM emp;

2. If Condition Activity: Check if the result is 'pass'. Use the below expression to evaluate:

@equals(activity('Lookup1').output.firstRow.result, 'pass')

3.Copy Data Activity: Inside true block of If condition 'pass', use copy activity to copy the result to Blob Storage by configuring the source and sink datasets.

Hope it helps. Kindly accept the answer by clicking the Accept answer button. Thankyou
Please sign in to rate this answer.
Vineet S 730 Reputation points

2024-08-29T06:49:50.0933333+00:00

how output will store in blob

AnnuKumari-MSFT 32,661 Reputation points Microsoft Employee

2024-08-29T08:06:36.4133333+00:00

Vineet S ,

To load it to the blob file, you can make use of copy activity and in source pass an empty dummy file and in additional column option, create a new column with the value having the required expression . In sink , point the dataset to the blob, and go to mapping tab and add the additional column by importing schema . Run the pipeline . You can take reference from the following video: How to get the list of empty and non-empty ADLS folders using adf pipelines

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Validation

1 answer

Your answer