How do i compare the two tables and pick the dummy table data with zeros , if the other ta

[dhruvakumar2]

How do i compare the two tables(dummy talble and other data table )  and pick the dummy table data with zeros and report the same , if the other data table is not processing , due to as the filter of the sub lob is with zero data in initial data filtering 

[alexnajm]

Can you give us sample inputs and your expected output please? It's hard to understand the question

[dhruvakumar2]

Thanks Alexnajam for responding 

 Here is the example 

Sample input -

1st step - I am filtering the excel columns with specific sub lob like Accounting sub lob , further steps will take on  only if accounting is available in the weekly report , otherwise its not giving a  output of the table if accounting sub lob in not available in the report , with no table generated 

Output - I want the table to be generated with zero values even though accounting sub lob is not there , as of  now no table is generated 

let me  know if additional information is required 

,

[dhruvakumar2]

Thanks Alexnajam for responding Here is the example Sample input - 1st step - I am filtering the excel columns with specific sub lob like Accounting sub lob , further steps will take on only if accounting is available in the weekly report , otherwise its not giving a output of the table if accounting sub lob in not available in the report , with no table generated Output - I want the table to be generated with zero values even though accounting sub lob is not there , as of now no table is generated let me know if additional information is required ,

[Gaurav_Dhama_]

@dhruvakumar2 can you provide a dummy input and expected output in excel, maybe created manually? 4-5 lines per excel should be sufficient I believe from what I can gather from the explanation. However, it will be easier to fully grasp what you expect if we have the example in hand.