Hi guys! I have a question. How could I join two data tables into one? The difficulty of this is as follows:
- Must contains ALL the data in DT1.
- It must be filtered according to column N° Doc.
If the DT2 has a Doc No. that the DT1 does not contain, add to the DT3. Otherwise, do not add.
- Don’t use filter for each activity with Filter data table activity (I used that method and these are usually tables of more than 100,000 rows. so it takes a long time and I am looking for something faster, like with LinQ, or else a faster method to process MANY rows and, using a foreach activity to check the N°Doc and then using a Filter Data Table activity to filter DT2, uses A LOT OF TIME)
Libro1.xlsx (26.6 KB)