
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I want to where data
Header 1 | Header 2 | Header 3 |
---|---|---|
Price | Ref.1 | Ref.2 |
500 | Oil | - |
900 | WAG | 2 |
700 | WAG | - |
800 | WAG | 3 |
799 | WAG | - |
where ref.1 not Oil and where ref.1 WAG not 2,3
EX.
Header 1 | Header 2 | Header 3 |
---|---|---|
Price | Ref.1 | Ref.2 |
700 | WAG | - |
900 | - | - |
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why 900 is there instead 799?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The correct answer should b:
Header 1 | Header 2 | Header 3 |
---|---|---|
Price | Ref.1 | Ref.2 |
700 | WAG | - |
799 | WAG | - |
Could you explain where do you want? Loading statement or graph?
OEM Solution Architect
LATAM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry i write wrong
EX. 700 and 799

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, you are correct.
I want to load data

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi, try this
TABLE:
LOAD Price,
Ref.1,
Ref.2
FROM
[data.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1)where Ref.1='WAG' AND not Match(Ref.2,2,3);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I load data from SQL but I want to load some data and I have Problem following
FROM "MIS_DataLake_UAT".dbo."SAP_COST"
where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),
where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),
where "S_REF_KEY_1" <> ('OIL'),
where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);
Problem

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I load data from SQL but I want to load some data and I have Problem following
FROM "MIS_DataLake_UAT".dbo."SAP_COST"
where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),
where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),
where "S_REF_KEY_1" <> ('OIL'),
where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);
Problem
incorect syntax near ','.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I load data from SQL but I want to load some data and I have Problem following
FROM "MIS_DataLake_UAT".dbo."SAP_COST"
where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),
where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),
where "S_REF_KEY_1" <> ('OIL'),
where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);
Problem
incorect syntax near ','.

- « Previous Replies
-
- 1
- 2
- Next Replies »