how to display with pre-fix and with pre-fix values

[Srinivas]

Hi All,

I want to display as like below screen shot way who have two values like with pre-fix value and without pre-fix value as a another table or qvd.

Am attaching file and data, Could you please help me on this.

Advance Thanks,

Munna

[robert_mika]

Not entirely sure but try this:

TextBetween( [Product Number],'-','') as ProductNumber,

[swuehl]

Or using subfield():

LOAD

     FieldWithPrefix,

     subfield(FieldWithPrefix,'-',1) as Prefix,

     subfield(FieldWithPrefix,'-',2) as FieldWithoutPrefix,

[ankitaag]

Hi Munna,

So you want 1 qvd with prefix values and 1 with non prefix values?

[#5]

If my guess is right for having two tables with and without prefix product number, create a flag and use it as below.

Product:

LOAD CHAN_ID,

     PROD_CD,

     [Product Number],

     Wildmatch([Product Number],'*-*') as Prefixflag,

     LOCATOR,

     LOCAL_CD,

     LOCAL_DESCRP

FROM

MLE.xls

(biff, embedded labels, table is Sheet1$);

NoConcatenate

ProductsWithPrefix:

LOAD *

Resident Product

Where Prefixflag=1;

QUALIFY *;

NoConcatenate

//ProductsWithOutPrefix:

B:

LOAD *

Resident Product

Where Prefixflag=0;

DROP Table Product;

[antoniotiman]

Hi,

try in script

Temp:

Load

....

from ....;

Table:

Concatenate

Load

Replace([Product Number],'20-','') as [Product Number]

Resident Temp;

Regards,

Antonio

[Srinivas]

No i want to see combination of both values in one qvd.

Regards

munna

[daniellial]

I think the solution is to do as Antonio said.

[Peter_Cammaert]

It took me a while to discover your exact requirement, but I think I may have a solution for you.

See the attached document. Please correct me if I'm wrong.

Best,

Peter

[help4qv123]

MLE:

LOAD CHAN_ID,

     PROD_CD,

     [Product Number],

     LOCATOR,

     LOCAL_CD,

     LOCAL_DESCRP

FROM

C:\Users\Downloads\MLE.xls

(biff, embedded labels, table is [Sheet1$]);

NEW:

load

CHAN_ID,

     PROD_CD,

     [Product Number],

     LOCATOR,   

    if (count(DISTINCT [Product Number]) > 1, concat(DISTINCT [Product Number], ', ')) as test

     Resident MLE group by CHAN_ID,

     PROD_CD, LOCATOR,

     [Product Number];

     drop Table MLE;

     STORE NEW into ' path ';