How to add a new field name 'No" as LOCAL_PRODUCT into my QVD table ?

[paulyeo11]

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

[#2]

Hi Paul,

Please use this case function along with QVD1,

case when PART_NO_ IS NOTNULL THEN 'NO'

end as Brand_Product

[Peter_Cammaert]

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)

[Anonymous]

Try this:

Null() as [Field Name]

[paulyeo11]

Hi Var

Thank you for your sharing , i not quite understand what you mean...

V

[Peter_Cammaert · Accepted solution]

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.

[Peter_Cammaert]

That's Oracle SQL. Doesn't work except in SQL statements.

[paulyeo11]

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