Question
Problem in converting Page list to value list
Hi Team,
I am taking input through excel file and using MSOParseExcelFile to create a page list and trying to convert pagelist to valuelist using data transform. Where I am trying to iterate on page list that I created through excel sheet and putting it into new valuelist property throwing me an error as its not getting source page.
***Edited by Moderator Marissa to update platform capability tags****
Hi Aishwarya,
Iterate over the page list in the source using 'For Each Page In'. set the repeating value using the (<APPEND>) subscript and reference the page in the page list as the source using the (<CURRENT>) subscript.
e.g.
'For Each Page In' SourcePage.PageList,
'Set' TargetPage.ValueListProperty(<APPEND>) = .PageList(<CURRENT>).PropertyName
Where the .PageList().PopertyName was the reference to a Pagelist in the current step page for the source column.