topic Re: Implement sql in script editor in QlikView

Implement sql in script editor

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have below SQL which I want to implement in Qlikview, I understand this can be done by script editor, please suggest options to do this

Select col1, col2

from table1, table2

where table1.col1=table2.col2

Gysbert_Wassenaar — Wed, 10 Aug 2016 14:26:38 GMT

See this video tutorial

Wed, 10 Aug 2016 14:27:26 GMT

table1:

LOAD col1 AS KEY ;

SQL Select col1 FROM SOURCE

//table2

INEER JOIN(table1)

LOAD col2 AS KEY ;

SQL Select col2 FROM SOURCE