Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below is the script which i load 2 QVD table.
PRICE:
load * from $(vQVDPath)BECKHOFF.qvd (qvd);
Concatenate
load * from $(vQVDPath)HAKKO.qvd (qvd);
My Question now is i want to add a new field name , let said :-
'No" as LOCAL_PRODUCT,
I try using the above line , i got error. any advise ?
Paul
Hi Paul,
Please use this case function along with QVD1,
case when PART_NO_ IS NOTNULL THEN 'NO'
end as Brand_Product
Again, put a specific value in BRAND_PRODUCT for your CONCATENATE LOAD (those 9 records), like
:
'Yes' as BRAND_PRODUCT,
:
Then reload. You cannot select NULL in a listbox, therefor you cannot directly select your 9 rows. However you can select the NO value and invert the selection (Select Excluded)
Try this:
Null() as [Field Name]
Hi Var
Thank you for your sharing , i not quite understand what you mean...
V
Also note that a table box is not an ideal object to show you what is in an internal table. A table box is really like a set of list boxes that show you the unique field value combinations for the current selection. If ever a field value of NULL pops up, that'll cause a new row to be displayed in a table box if and only if that same row hasn't been displayed already before.
That's Oracle SQL. Doesn't work except in SQL statements.
Hi Peter
You are right , i have manually go to individual QVD table create a field name :-
'House Brand' as TYPE_PRODUCT,
and now i am able to filter all House Brand. it work fine. conclusion no short cut.
Paul