How do I input a default value for blank fields?

I have 4 XML files I parse, union and output to a Tableau TDE file.

The union output has 3 years of data. But, one of the XML files only has data for 2 of the 3 years. So, when parsed that year is not a available which means in the union output there are no rows for that year for data from that XML-- then in Tableau it shows up as a blank. How can I automatically generate rows for that missing year and default to "0"?

I tried imputation - but since the year does not exist for that XML then it can't assign a "0"

Thanks

Common Use Cases

Accepted answers

derekbelyea

This example should point you to a solution. The example below and attached has monthly data for four divisions (A, B, C, D) over four years (2010, 2011, 2012, 2013).

However there are no records for Division D in 2010 and for Division B in 2013.

FillMissingPeriods.yxmd

All comments

derekbelyea

Data cleansing tool should solve that.

hellyars

Sorry, I don't understand how.

The problem is that some of the XML inputs for a given entry have all the years or just one of the years. When I parse it, the rows for that given year are missing - because they don't exist. So, how can I add them back in -- given that some entries might have them and other might not (and there is no pattern)?

rahul1011

you can use the generate rows tool to generate rows for years which are missing.

derekbelyea

This example should point you to a solution. The example below and attached has monthly data for four divisions (A, B, C, D) over four years (2010, 2011, 2012, 2013).

However there are no records for Division D in 2010 and for Division B in 2013.

FillMissingPeriods.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703