Hi team.
I'm unable to perform my query in Tableau. I receive an ERROR about ambiguity. I checked in this forum and people say I need to adjust the column names using alias, but I'm not proficient with queries and I would like to humbly ask for help on what should I do.
Kindly help me out in this matter.
select *
from SDM.HZ_JIRA_PROJECTS JP, SDM.HZ_QM_M_TEST_RUN TR, SDM.HZ_QM_M_TEST_RUN_EXTENSION TRE
where TR.TST_RUN_ID = TRE.CORE_REC_ID
and SubStr(SubStr(TR.SRC_SYS_NM, (Instr(TR.SRC_SYS_NM, '(', -1) + 1)), 0, Length(SubStr(TR.SRC_SYS_NM, (Instr(TR.SRC_SYS_NM, '(', -1) + 1))) - 1) = JP.SPK
and TR.SRC_SYS_NM Like '%qTest%'
and Upper(JP.SPK) = 'BRZCIO'
and TRE.FLD_VAL_TX in ('BRZCIO.2023.PI1.S3', 'UAT')
Hi @Bruno B​, do you have someone internally who might know more of the context behind the tables, what's being selected, and why? Matz is right, this seems to be more of a question about SQL more so than the Tableau side. However, if you can find someone who can explain the 'why' to you, you may be able either figure out another way to do it or (once you have more context) we could suggest something from there (I can't guarantee, but it's worth you doing some homework on it first internally perhaps 🙂 ) Cheers, Katie
