Whilst recently compiling a reasonably complex transformation to bring
in some data from an Excel spreadsheet I was left in the situation where
I had a some look ups that were failing to resolve due to case
sensitivity. This was a failure on my part really as I should have
understood from the outset that this could have been the case and I
should have factored this in from the start but I didn’t. No problem
usually, You can just change the case at the source and and in the
look-up component and you’re there. However… In my situation this was
not feasible without me throwing myself out of the nearest window and
making finger paintings with my own blood in my dying moments. The
reason for this is that I had about 50 separate sources which is an
onerous task in itself. In addition to this as I was ‘unioning’ all of
this data together using the union component and then going through
several more complex transformations with additional unions along the
way it was getting very messy, The union components do not refresh with
new fields when the source changes and so the only way to correct this
is to drag new union components on in place of the old ones! This in
turn means that all of the adjoining components also need to be
refreshed and even talking about it I can feel the end approaching.
Read the full blog here.
Written by Conrad Rowlands, Team Leader and Developer, DSCallards
No comments:
Post a Comment