kumar25 - The dev team has informed me that the Excel Parser only supports XLS and XLSX formats today. So requesting support for XLSB would be an enhancement request, which would need to be evaluated and prioritized according to the number of customers impacted and weighed against other priorities.
So I would recommend that you research Java or Python libraries that can parse the files that you are trying to source, then look at how to implement that with the Script so it can be called within your pipeline.
Hope this helps!
adam_gataev - you have the right terminology. Just use a Mapper as follows:
Here I'm just using two Array methods: concat() and pop() to complete your goal in one expression. The Array.pop() removes the last element and returns that element. The Array.concat() creates a new array with the new element added in.
Note that I'm also using the "pass-through" option on the Mapper settings. This allows any other elements in the input doc to flow through to the target path without specifying them.
Hope this helps!
You're the man koryknick, thank you so much!
