Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
All fields are same so both tables get concatenated. If you want different tables then use NOCONCATENATE in between.
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;
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;
noconcatenate
but why you want 2 tables with the same data?