Adding new row in a table

[#1]

hi All,

I am attaching this document which explain my situation.  I have Category with A,B and C values.   and when i Pick A , i see A1,A2 and A3 as SubCategories in Sucategory field.

I want A in Category to only show A1,A2 in Subcategory. and have new value in Category as A_Excluding_A1 and when i select that i only get A1 in Subcategory.

Please see attached screenshot. I want this to be done in script.

.

[somenathroy · Accepted solution]

Hi,

Try with the below code:

LOAD *

FROM

[MyTable.qvd]

(qvd)

Where not Match(SubCategory,'Toothpaste');

Concatenate

LOAD DivisionKey,

     Division,

     SubsidiaryKey,

     Subsidiary,

     CategoryKey,

     Category & ' ' & SubCategory as  Category,

     SubCategoryKey,

     SubCategory,

     CalKey,

     CalYear,

     Month,

     Year,

     [Inventory Value],

     [GROSS PROFIT MARGIN],

     [NET SALES],

     COSG,

     counter,

     AvgCOSG

FROM

[MyTable.qvd]

(qvd)

Where Match(SubCategory,'Toothpaste');

Regards,

Som

[#3]

Thank you Som