Hi,
I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible?
Thanks
You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)
@CommunityMember113484
Sadly I do not think this is possible via the UX or modelling environment.
However, I would explore using the add ins for Excel where you can create a dynamic link into your model and have the Excel update directly within Excel.
@CommunityMember113484 While exporting, Pivot the product dimension into Pages. Now you can use Export>Grid Layout option and select "All Pages" radio button to export all the products data in single workbook with each product in separate tabs.
Hope this helps
AB
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
