Converting Varchar data into Datetime
Hi everyone,
I’ve been trying to convert data I’m receiving from a varchar (20171211 125023) into a datetime (2017-12-11 12:50:23). I’ve been messing with the mapper but I feel like I’m at a road b...
Forum Discussion
Are you executing the pipeline using the Validate button? If so, try holding the Shift key when you click the Validate button. That will bypass caching.
I want to know list of columns using expression in mapper snap.
- When I write $.keys() expression its fetching all the columns for all the rows which to performance issue. I need only first document or first row.How are you using those columns downstream from the mapper? One performance improvement would be to only do the call to $.keys() once and use that information. However if you need to join it with each document, then I'm not sure that would improve anything. If you only use it in some kind of load/write operation, then maybe that would be an improvement for you.
