topic Re: show null values for the missing years data in App Development

show null values for the missing years data

vidyasagar159 — Sat, 16 Nov 2024 21:02:48 GMT

Hi All,

Hope you are doing great. I have a small requirement. As I am working on product historical data. This product launched in 1976 (Product Inception Date) with some sale figure. But I have the data available from only 1985 (Year).

So Product Age = Product Inception Date - Year

Since I don't have data from 1976 to 1984 I would like to show null values in the Year Column.

Re: show null values for the missing years data

saminea_ANZ — Tue, 16 Apr 2019 02:00:52 GMT

Please generate the calendar from 1976 to data available? So, It will generate with null values where data is not available and remain will store from source and linked together.

Re: show null values for the missing years data

vidyasagar159 — Tue, 16 Apr 2019 15:33:23 GMT

I got this idea already. But the tough part is I have millions of products like this on top of this the source files are excel. Of Course, it can be done by adding more calendar years in excel. Just checking in if there are any alternatives like ApplyMap().. etc.