Multiple Data Loads

[Shashank1987]

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?

[mayuringale25]

Hi @Shashank1987 

Check the attached qvf. 

Hope you want this model