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.

[dhruvakumar2]

Hi Gaurav 

Here is the example sample data i have given in two excel files , wtih sales and without sales data . I want the alteryx workflow to work even the sales data is not there in second excel file and give the table b values with zero values .

As of now if the sales data is not there , workflow stops and table is not generated . Hence i had to maually create a table with zero values 

[LindonB]

Hi There,

I think I follow what you're asking. Are you asking for either (i) how to include rows with a zero value after a join in the final table or (ii) how to return a list of the locations without sales data? If it's either of these two, I would either list or group by the combination of the location and department and join that in. That will generate null rows which can be filled with zeros. See attached. If this isn't what you're asking for, please let me know and clarify the request. (Note that if you only want what was in the dummy table, just take the right output of the join or filter at the end.)

Lindon

[Gaurav_Dhama_]

Attached is the workflow showing how I would do it. I am assuming that what you have asked is a smaller part of a bigger workflow and you will have a list of locations and departments as a list or within the data even if amount is 0.