Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
.
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
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
Thank you Som