Dear all,
I hope you can help me. I looked for answers but couldn't find any. I am trying to create a workflow to compare:
- an Excel file that contains study configuration "on paper" (it can have various amount of rows depending on the study)
- a SQL query that contains the study configuration in the system
I need to compare the 2 to verify if there are any mismatches.
I managed to create a workflow based on a particular study ID but then I realized that each Excel file will have a different amount of rows and I don't know how to "tell" that to Alteryx to consider only the rows that have data. I tried to use Select Records (but this would work only if EVERY study configuration excel file would have an equal amount of rows, right?) and/or Data Cleansing tools but the output file still shows null rows/columns.
Any ideas?
Thank you so much for your help!
Kind regards,
Ioana
