Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

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
Honored Contributor 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
Valued Contributor

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
New 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?