topic assign previous non empty value to dimension in App Development

assign previous non empty value to dimension

sujit_nath — Sat, 19 Jun 2021 18:31:52 GMT

I have a data, like -

I want to show the output like:

Month Year	Sales
Jan-18	10
Feb-18	10
Mar-18	10
Apr-18	20
May-18	30

Basically, The date range can be created with master calendar (that's fine), but I need to assign the value of each blank MonthYear with its previous non empty value.

How to do this? Thanks in Advance!!

Re: assign previous non empty value to dimension

saniyask — Sun, 20 Jun 2021 06:13:28 GMT

Hi,

Load the data, create calendar. Create a resident of your original table and construct a new table like below.

noconcatenate

Tab1:

Load *,

if(isnull(Sales),Peek(Sales),Sales) as Sales

Resident Data

order by Date;

Drop Table Data;

Hope this will help.

Regards,

Saniya