nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Reporting

Accepted answers

All comments

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

With Sales Data.xlsx

Without sales data.xlsx

table .jpeg

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

20260112_A.yxmd

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.

20261301_DhruvKumar.yxmd

alexnajm

@dhruvakumar2 can you mark one or more of the responses as a solution to close out this thread? Thank you in advance!

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15910

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703