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.