Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SELECT * FROM TABLE1 ,TABLE2,TABLE3
WHERE
TABLE1.PRODUCT_KEY=TABLE3.PRODUCT_KRY
AND
TABLE2.PRODUCT_PART.NO.=TABLE3.PRODUCT_PART_NO.
AND
( TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'
or TABLE1.INTP_TYPE in ('s', 'd')
and TABLE2.PRODUCT_PART_NO.= '20398' );
SO, my question is that, where i will use this filter condition.----
TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'
or TABLE1.INTP_TYPE in ('s', 'd')
and TABLE2.PRODUCT_PART_NO.= '20398
Are you facing any problem if you use this as it is in the script load statement?
Since this is your load script that is the only data that will make it into your app.
If you then added filters for those fields on a sheet you would only see the values that you selected in the Where clause.
Yes, actually, this is not single filter condition .
I am telling you the original scenario.
Load PRODUCT_KEY from
table.qvd;
i
load PRODUCT_PART_NO, PRODUCT_KEY from
table3.qvd;
Load PRODUCT_PART.NO from
table2.qvd;
Now, where i will use this condition, If , i use this filter condition ----
(TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'
or TABLE1.INTP_TYPE in ('s', 'd')
and TABLE2.PRODUCT_PART_NO.= '20398')
I am telling you the original scenario.
Load PRODUCT_KEY from
table.qvd;
i
load PRODUCT_PART_NO, PRODUCT_KEY from
table3.qvd;
Load PRODUCT_PART.NO from
table2.qvd;
Now, where i will use this condition, If , i use this filter condition ----
(TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'
or TABLE1.INTP_TYPE in ('s', 'd')
and TABLE2.PRODUCT_PART_NO.= '20398')
I am telling you the original scenario.
Load PRODUCT_KEY from
table.qvd;
i
load PRODUCT_PART_NO, PRODUCT_KEY from
table3.qvd;
Load PRODUCT_PART.NO from
table2.qvd;
Now, where i will use this condition, If , i use this filter condition ----
(TABLE1.INTP_TYPE in ('i', 's', 'c') and TABLE2.PRODUCT _PART_NO<> '20398'
or TABLE1.INTP_TYPE in ('s', 'd')
and TABLE2.PRODUCT_PART_NO.= '20398')
So, you are saying that, i have to use this condition into sheet.
IN that case, i have product_part_number column into my app sheet, so how can i write the fileld expression into this particular column.---PRODUCT_PART_NO.
can i use this expression:------
if(match(invc_flag,'i','s','c') or NOT match(invc_flag,'s','d'),product_part_no.,'20398')