Is it possible to drop the first three digits in a name?
I need to drop the SQL in the data.
You can try:
Sure, try this may be:
Right(LastModBy, Len(LastModBy) - 3)
Try do this in Qlik part of Script (above SQL Select), not in SQL code.
still get error like above
Example of correct code here:
right(LastModBy,len(LastModBy)-3) as LastModBy;
Now my join does not work
Use alias, your field in "Rxs" table must be named as "LastModBy", like in another table.
right(LastModBy,len(LastModBy)-3) as LastModBy
I think u missed the rename "as LastModifiedBy" in table RXS
Retrieving data ...