Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have issue in using excel file field into not match func. I have excel file which has one field and two values in it.
Country |
Japan |
Malaysia |
I need to exclude these two values in my report. So I have used
Below Load statement :
where Not Match (Country , 'Japan', 'Malaysia') ---- this works fine.
But I need to directly give that excel file column name in my load statement.
I have loaded data into data load editor.
Country: // table name
Load
Country // Field name
FROM $(Country_File) //variable created
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1)
I have used like this
where Not Match (Country_SQL , Country) // This Country_sql comes from main table where i need exclude these two values. // Country is Excel field
But, country column is not found error iam getting
Please help me ASAP.
Thanks in Advance
change where Not Match (Country_SQL , Country) to where Not exists (Country_SQL , Country)
Hi @Kushal_Chawda ,
Thanks for Replying!
It Throws same error, Country field not found after giving not exists ().
Hi @Kushal_Chawda ,
In General,
How to read field values from excel sheet? do we need to give function?
make sure that first parameter of exist is field name from first loaded table and second parameter should be field name of existing table where you are applying where clause.
Table1:
load *,
Country_SQL
FROM table1;
table2:
load *,
Country
FROM table2
where not exists(Country_SQL,Country);