topic Re: Duplicate Table Name Within From Statement in QlikView

Duplicate Table Name Within From Statement

michaelsmith — Wed, 25 Nov 2020 16:16:04 GMT

I'm working on a QWV created by someone else and it's doing something I've never seen before.

The application extracts records from a database using code similar to the follow:

SELECT x,y,z

FROM TABLE_NAME TABLE_NAME

I don't understand what the repetition of the table name is doing? If I simplify it to the following code less records are extracted.

SELECT x,y,z

FROM TABLE_NAME

Can anyone shed any light on why this is the case?

Fri, 04 Mar 2016 07:20:58 GMT

Hi Michael,

I think it might be the alias name of the table name

Thanks,
Sreeman

Anonymous — Fri, 04 Mar 2016 07:24:13 GMT

Which database or data source?

vikasmahajan — Fri, 04 Mar 2016 07:32:10 GMT

It could be this

SELECT x,y,z

FROM DBname.TableName

Vikas