I need help with SSIS Conditional split. I have attached a create tbl script and test data.
I need to split data in multiple columns so that i can use that data in SSRS. The issue is that the data is mixed up and vary in length
The column in mind here is "Client_user_agent", the split should have a Browser and Devices column. The first few characters they are terminated with "/" then a number then "(" in here it's either a device or a browser then terminated with ";", so thus far i need data
I hope it will make sense with test data
It's better to fail while trying, rather than fail without trying!!!