Anyone have ideas on how I can use ADF to compare two files?

Create an ADF pipeline and add two Copy activities to the pipeline. Configure the source for each Copy activity to be the location of the file you want to compare, and configure the destination for each Copy activity to be a temporary location in your Azure environment, such as an Azure Blob Storage container. Add a Lookup activity to the pipeline and configure it to read the contents of the two files you copied in the previous step. You can specify the file format and delimiter in the Lookup activity's settings. Add a Conditional Split activity to the pipeline and configure it to compare the contents of the two datasets. For example, you could use an expression like @equals(activity('Lookup1').output.firstRow.Field1, activity('Lookup2').output.firstRow.Field1) to compare the first row of each dataset based on a specific field. You can define multiple conditions and specify the outcome for each condition using the Conditional Split activity's settings. Add a Sink activity to the pipeline and configure it to write the results of the comparison to a destination location, such as an Azure Blob Storage container or a SQL Server database. Save and publish the pipeline.