Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Reg: Loading with one table in 2 datasets

Hi ,

I am having scenario like this.

STATUS1:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

STATUS2:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

After running the script I am getting only STATUS1

Please let me know how to achieve STATUS1 and STATUS2  after reloading without any issue.

Thanks a lot

Lakshmana

4 Replies
Highlighted
Master III
Master III

Re: Reg: Loading with one table in 2 datasets

All fields are same so both tables get concatenated. If you want different tables then use NOCONCATENATE in between.

Highlighted
Specialist
Specialist

Re: Reg: Loading with one table in 2 datasets

Hello! you should use noconcatenate or qualify or rename your fields in second table

try this

QUALIFY *;

STATUS1:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

STATUS2:

SELECT      

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

Highlighted
Contributor III
Contributor III

Re: Reg: Loading with one table in 2 datasets

Agreed

you can use Qualify *;...Unqualified.

NoConcatinate I find is more useful.

eg.

[STATUS1]:

NoConcatenate

SELECT     

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

[STATUS2]:

NoConcatenate

SELECT     

TOOL_ID,

LOT_ID,

LOT_STATUS From LOT_CATEGORY;

Highlighted
MVP
MVP

Re: Reg: Loading with one table in 2 datasets

noconcatenate

but why you want 2 tables with the same data?