I have a certain column in Discoverer that I need to separate:
What I need it to do is separate by the * no matter what:
Should Look Like This At The End:
ID NEW COLUMN
I don't know how to create this calculation, can someone please help me out?
Thank you in advance for all your help!
I read it but it still doesn't help me figure out calculation issue.....i am a little new to the discoverer world, is there anyone that can help me with this?
problem has NOTHING to do with Discoverer & everything to do with basic knowledge of SQL
can you write SQL when you do not know table name or column name where the data resides?
The question was simple:
I am trying to do is bring in anything after the * in the Id column no matter how long the name is before the * but my calculation is way off L:
Here is an example of what my data would look like but what I need it to do:
Id NEW COLUMN
Do you know how to create this calculation?
this was emailed to me from someone on here saying "try to see if this helps" and it did that's why i said thank you.