Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy there. I`m trying to LOAD data from a table but I want to exclude some info when a String does not contain a subString.
The querry looks like this
LOAD
COLUMNS;
SQL SELECT *
FROM MY_TABLE
WHERE COLUMN_NAME not like '*subString*';
But this isn`t working. It brings all the data.
What am I doing wrong?
Thank you.
Which is your back end database??
SELECT *
FROM MY_TABLE
WHERE COLUMN_NAME not like '*subString*'
this is actually the SQL query part , try executing this against the database and check the error
Which is your back end database??
SELECT *
FROM MY_TABLE
WHERE COLUMN_NAME not like '*subString*'
this is actually the SQL query part , try executing this against the database and check the error
Thank you for your answer.
I solved it. It was just a simple sql query.
Hi Razvan,
You can use the below as an alternative solution.
LOAD
COLUMNS;
SQL SELECT *
FROM MY_TABLE
WHERE not WildMatch(COLUMN_NAME,'*subString*');
Thank you for your answer.