We are using the Table Difference Finder to validate data transformations and verify that target tables match the source for tests. This is a great way to automate our tests but I’d like to create a file or report that shows the statistics of differences (hoping for zero) and do this for a number of table difference finders so that I can run tests on 10 tables and then output the results for audit purposes. I’ve been playing with Cross Joiner, and other nodes but not having a lot of luck, especially when trying to combine the results for each of the 10 flows.
Hello @UtilityHawk,
From my understanding of what it sounds like, you got multiple flows, which. I assume you are trying to tie them in together at the end for a report.
A simpler way I can think of is you should wrap these flows in a component and try out the reporting extension. Take each of the 10 resulting tables and compile them into 1 pdf for the report.
Although if you specifically want the 10 result tables to be combined, I think a Concatenate node would be more applicable than a cross join as cross joins are intended to produce every possible combination of rows based on the input tables.
TL
2 Likes