I have two flat file and it contain common one column values is equal to two flat file. so normally we using inner join and retrieve data, but here my scenario not equal to be display in the report?. If anyone known this answer help to me.
Considering that you have ID field common.
Load * Inline
Where Exists (ID);
Retrieving data ...