Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Sep 25, 2014, 3:06 PM

RAWSQL

Looking for assistance for the Query below to work in Tableau.

 

IIf([Site PN] Like "*#","MFG",IIf(Len([Site PN])-Len([Part Number])>0,Right([Site PN],Len([Site PN])-Len([Part N@umber])-1),"MFG"))

1 answer
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Oct 3, 2014, 9:15 PM

    Hey Todd Thomsen,

     

    I'm still working my way through custom SQL basics so I'm probably not much use here. However, providing a use case for the query above may help other users identify the desired outcome and be better able to assist. Packaged workbooks are also always a huge help! :-)

     

    Thanks,

     

    Diego

Write an answer...
0/9000