Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a new table with multiple rows for each ID based on date.

Hello everyone, and thank you in advance.    I have a dataset with this general form:   I am trying to generate a table that has a row for each date in between the start and end date inclus...
General Comment
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

    With Query Editor

     

    Add this Custom Column

     

    ={Number.From([Start])..Number.From([End])}

    Now Expand it to new rows

     

    Now convert this column into date format

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

With Query Editor

 

Add this Custom Column

 

={Number.From([Start])..Number.From([End])}

Now Expand it to new rows

 

Now convert this column into date format

PradeepDive's avatar
PradeepDive
Icon for Helper II rankHelper II
5 years ago

Thats awesome... curious to know how that works.. can you explain.