Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hello,
In Data load editor if you have the following script:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...);
The outcome is the entire table:
However adding the WHERE clause:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...)
Where NOT Status = 'H';
Will give you:
As you can see, all the records where Status field equals with "H", are missing
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hello,
In Data load editor if you have the following script:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...);
The outcome is the entire table:
However adding the WHERE clause:
LOAD
tem_No,
Status,
"Date",
Segment,
Amount
FROM [...]
(...)
Where NOT Status = 'H';
Will give you:
As you can see, all the records where Status field equals with "H", are missing
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
