filter and lookup transformation

Question

Hi,

have 2 tables table1 .jobid 1

table2 tjob2.jobid1 and jobname='test'

how to filter jobid1 where jobname<>'test'

Answer 1

@Vineet S ,

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

Lookup transformation in dataflow of Azure data factory works similar to left outer join in SQL . All rows from the primary stream will exist in the output stream with additional columns from the lookup stream.

Could you please share what is the record count for source1 and source2?

If you want to fetch all records where jobname is not equals to test then kindly use '!='

Also, you can use Join transformation in case you want to perform inner join between the sources

Hope it helps. Kindly share more information in case you need further assistance. Please mark the answer accepted if it helped. Thankyou