1 of 1 people found this helpful
You could "strong arm this" and create 11 calculations to get the job done:
MID([Full String Name],2,8)
MID([Full String Name],9,10)
...and so on. That's a slow-but-simple way of getting the results you need.
I'm no SQL whiz, but you may have better luck loading the data through SQL and creating your columns that way.
You can use MID in SQL:
SELECT SUBSTRING(column_name,start,length) AS some_name FROM table_name
...then define your 11 calcs this way. Based on the size of your data set, this may be faster than creating the Tableau calculations .
How do I mark this ans as Correct. I don't see any option in Actions to mark it as correct
Hi Archana-- glad I could be of help!
Make sure you are logged in and you should see at lower left of the appropriate comment "Mark as Correct."
Let me know if that doesn't work: I think this was originally posted in VIZ Talk and moved to Forums (my brain may be foggy, though). If that's the case, you may need to get a helper.