Hello Community,
I have two tables "DTE" and "BCO". I want to get the "Table Except"
Use the concept of Except using Filter Array. I concatenate the items of each column of each table, but I can't get the expected result. Is the flow I made ok?
It is an example or test table
My Flow
Solved! Go to Solution.
Hi @fgonzalez515,
Based on your description, I have made a simple test for your reference.
1. I have a Excel file called FilterArray, it stores three tables (Table1, Table2, and Table3).
2. Here is my flow:
@and(equals(item()?['Rut'], items('Apply_to_each')?['Rut']),equals(item()?['CR Luciano'], items('Apply_to_each')?['Obra']))
length(body('Filter_array'))
3. Result screenshot:
Best regards,
Sylvia
Hi @v-peijunz-msft,
Thanks for you information.
Is there any other way to make the flow run faster?
The number of items to review is more than 10,000.
Any other option?
Due to the number of items, the Flow has been running for more than 4 hours
Any other option?
This link is helpful
https://www.damobird365.com/efficien-union-except-and-intersect-great-method/
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
12 |
User | Count |
---|---|
128 | |
53 | |
38 | |
26 | |
21 |