showing zero when there is no source data available for few weeks

[TE271203]

There is a weekly source feed getting where we have material number (part_number), atp & sales_org has atp value 0 or non-zero. When i join this with Sales Table based on material_number, i would like to show data on dashboard with rolling 12 months. But the challenge is that, in all fiscal weeks same part_number won't be available. so, wherever there is no value from data from source, there should be dummy data (part_number) and the atp value should be 0.

Attached screen is for reference where for few weeks the part_number and atp value doesn't exists but i would like to show same part_number into other weeks as well but atp should be 0. Please assist.

[ChrisTX · Accepted solution]

The attached workflow should give you a good starting point.  The Generate Rows tool is the key.

 

Chris

[TE271203]

Thanks a lot for your help Chris. I could able to see the desired result (Attached first screen shot) if i test with one single Part Number 1-1564542-1 but when i did load the full data, i see different result with additional data (attached second screen shot, not sure how it is getting loaded). is it anything to do with warn/error setting in Append Fields Tool or anything further to add. Please assist on how to handle large data?

[ChrisTX]

You need to adjust the Summarize tool and Join tool to match your key fields.

attaching a sample workflow with enough test data would help. Use Options > Export Workflow to create a YXZP file, to include the workflow and input data files.

[TE271203]

Hi Chris, now by adding part_number in join, i could see the correct result in table and tableau as well. Thanks for your help.