How to Pull data from different dimensionality?

araj

Source module:

Dimension Name Retire code

Line Item: Start date, End Date, Retire code

Target Module:

Dimension : XYZ

Line item: Launch Date(Populated Field) , Retire code( Pull from Retire code module based on launch date)

and the condition of logic should be if launch date is in between start date and end date of retire code module then pull retire code

Prajjwal88

Hi @araj ,

To check Whether Launch date from XYZ module lies within start and end date from Retire code module you'll have to do a cross dimensioning and then pull all the retire codes which follow the correct condition.

Also there could be case where multiple Retire codes which could lie within the start and end date from Retire module based on Launch date from XYZ module so to pull all those I have currently used a TEXTLIST function (Which is obviously not the best practise) but in order to get a workaround we do need to know if we can simply pick the First or the Last Non-Blank retire code then there's no use of textlist but if we do need to identify all the ones then there could be some other workaround. please refer to below screenshots for further explaination,

Hope this helps!