Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to convert a SQL procedure to Qlikview script.
DataTable:
Policy Number Policy Name Flag
1| ABC| Flag1
2| ABC| Flag1
3| ABC| Flag2
4| ABC| Flag3
SQL Script:
Insert into Policytable
Select * from DataTable ;
Insert into Policytable
Select * from DataTable
where Flag <> "Flag1"
Insert into Policytable
Select * from DataTable
where Flag not in ("Flag1","Flag2")
Can this be replicated in Qlikview?