I'm using BC4 Standard on Win7 Ent 64 bit
I'm doing a File Compare of two .xls files, and I'd like to extract just the orphan rows from the left file.
There were only 10 left orphans, so I just went through it manually using CTRL-Mouse Click to select those rows, Copy, and Paste to get the results. However, if this were a large file with lots of orphans, this might not be a practical solution.
I went sifting through the Script Reference for BC, but I'm not seeing a way to select the orphans.
I did a Table Compare Report, HTML report, Copy to Clipboard, and pasted the results into an editor. It looks like I could data munge a solution looking at DataItemSigOrphan, but it stills seems rather inelegant and brute force.
I'm doing a File Compare of two .xls files, and I'd like to extract just the orphan rows from the left file.
There were only 10 left orphans, so I just went through it manually using CTRL-Mouse Click to select those rows, Copy, and Paste to get the results. However, if this were a large file with lots of orphans, this might not be a practical solution.
I went sifting through the Script Reference for BC, but I'm not seeing a way to select the orphans.
I did a Table Compare Report, HTML report, Copy to Clipboard, and pasted the results into an editor. It looks like I could data munge a solution looking at DataItemSigOrphan, but it stills seems rather inelegant and brute force.
Comment