- Posts: 568
- Thank you received: 72
Excel Reader Sheet Mask
- bruce.gibbins
- Topic Author
- Offline
- Platinum Member
-
2 years 5 months ago - 2 years 5 months ago #20875
by bruce.gibbins
Excel Reader Sheet Mask was created by bruce.gibbins
Hi
One of our partners has been sending two files for some time now with a Sheet name in each that has the Words "Portfolio Exposure" in the sheet name. They have just started to send it with "Portfolio exposure" and the transformation failed as it could not find the sheet based on a mask. As I am not sure if they will transition back to the way they were sending it.... is it possible to make the Mask case insensitive?
On the same note. Is there a way to just dynamically pick Sheet 1 or 2 or 'n'. In know in the dialog box you can chose which sheet. But it goes by name. As it turns out for us they send 2 separate files for different entities. But we can use the same transformation for both. The only thing that changes is the sheet name and in one it might say "YYY Portfolio Exposure" and in the other it may say "ZZZ Portfolio Exposure". We need to just select this sheet ignoring YYY and ZZZ but then downstream we do need to use the sheetname to identify the Fund that the data relates to.
thanks
One of our partners has been sending two files for some time now with a Sheet name in each that has the Words "Portfolio Exposure" in the sheet name. They have just started to send it with "Portfolio exposure" and the transformation failed as it could not find the sheet based on a mask. As I am not sure if they will transition back to the way they were sending it.... is it possible to make the Mask case insensitive?
On the same note. Is there a way to just dynamically pick Sheet 1 or 2 or 'n'. In know in the dialog box you can chose which sheet. But it goes by name. As it turns out for us they send 2 separate files for different entities. But we can use the same transformation for both. The only thing that changes is the sheet name and in one it might say "YYY Portfolio Exposure" and in the other it may say "ZZZ Portfolio Exposure". We need to just select this sheet ignoring YYY and ZZZ but then downstream we do need to use the sheetname to identify the Fund that the data relates to.
thanks
Last edit: 2 years 5 months ago by bruce.gibbins.
Please Log in or Create an account to join the conversation.
