In SAC Data Wrangler, can I generate multiple rows of data based on start and end date records?

[VivekD]

Can I do this in SAC Data Wrangler and load into fact table of a model?

[N1kh1l · Accepted solution]

@VivekD 

Unfortunately you cannot in Data Wrangling but this should be easy to do in SAC Advance Formula. A simple logic to post 1 whenever the date is within the start and end date.

Nikhil

[VivekD · Accepted solution]

Thanks for your response.

Can you elaborate a little more on what you are suggesting. Would I need to land the base data first into a staging model and then use a Data Action with the Advanced Formula to convert that single row into 6 rows of data and post it into the final model?

[N1kh1l · Accepted solution]

Yes Vivek you have to stage the base data first either in same model in a different version or in another model depending on data volumes and other design considerations. Once base data is in, Adv Formula can be used to generate the multiple records.