Solved
How to read .xlsb file
Hi I have to read data from .xlsb file. I tried to use Excel parser but it is throwing error.
Forum Discussion
@sdoscher I am not 100% sure if I understand your requirement correctly, but as per my understanding you can read execl#2 parallelly then parse it .After that do a join (inner/outer or left outer) just before your mapper by your key element from both execl1 and excel 2. Then use mapper for creating new set of data whatever is required.
Any idea on converting the LDAP DateTime string?
Specifically the LastLogOn?Found it!
Date.parse(parseInt($Date)/10000 - 11644473600000)
Where $Date is LastLogon or LastLogonTimestamp from AD.
Check this link too… Converting Varchar data into Datetime - #11 by anivtk
