Where Clause

[Nikhil2725]

Hi Team,

I'm taking the data from the MS Access and need to add the where clause while loading the data.. Kindly help me in this..

Sample Data.

LOAD PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc";
SQL SELECT PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc"
FROM "C:\DB Project\DB Project\Backup (34429) of tutorials".PH9;

[Anil_Babu_Samineni · Accepted solution]

Perhaps this

LOAD PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc" Where PH9='Value';
SQL SELECT PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc"
FROM "C:\DB Project\DB Project\Backup (34429) of tutorials".PH9;

[Nikhil2725]

Hi Anil,

we can update the Where conditions at the end as well....

LOAD PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc" ';
SQL SELECT PH9,
"PH9_desc",
PF3,
"Div",
"Div_desc"
FROM "C:\DB Project\DB Project\Backup (34429) of tutorials".PH9 where PH9='Value';

[Anil_Babu_Samineni]

Off course, If you need any Qlik mechanism this won't work for you since SQL function and/or Qlik functions are not the same 🙂