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
Solved! Go to Solution.
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)?
I should note, that for the ones that don't have a year -- the actual source XML skips that year (as in its not present).
you can use the generate rows tool to generate rows for years which are missing.