Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Gud 1
Thanks Peter,
I hope its correct in frontend but i need in backend as a qvd like below screenshot way,
Advance Thanks
munna
Yes Ankita,
Could you please suggest to me how to do.and hoe make this.
First of all you have to identify , in which condition you want to display with pre-fix and without pre-fix.
Based on some column you should write IF ELSE (Case Statement in you script) or in application and will work perfectly.
From your Screenshot I can see If LOCAL_DESCRP is not NULL then you want to display with pre-fix else without pre-fix.
So you should write case statement based on column LOCAL_DESCRP or else identify the right column from you data and write case statement.
Hi Shivendoo,
Can you please give me example application.
How about this?
RawData:
LOAD CHAN_ID,
PROD_CD,
[Product Number],
LOCATOR,
LOCAL_CD,
LOCAL_DESCRP
FROM [.\MLE.xls](biff, embedded labels, table is Sheet1$);
LEFT JOIN (RawData)
LOAD PROD_CD, COUNT(DISTINCT [Product Number]) AS Occurrences
RESIDENT RawData
GROUP BY PROD_CD;
FinalTable:
NOCONCATENATE LOAD * RESIDENT RawData WHERE Occurrences > 1;
DROP Table RawData;
STORE FinalTable INTO [.\MultipleProductNumbers.qvd] (qvd);
See attached document for an example. Modify to suit your needs.
Peter
Thanks Peter,
It's almost correct but I need one more modification , In our scenario displayed when CHAN_ID is different, Here I need wherever CHAN_ID should be same and then product number have pre-fix and without pre-fix value i need to display.see below screenshot ,this is my requirement.
Regards,
Munna
Hello Peter can you please help me on this scenario.
Best,
Munna
You should have a field that ties rows together (e.g. in your example the two rows have no relation except an identical CHAN_ID). If it isn't present, create one. For example, when loading the data from excel, create a new field without optional prefix, like:
...IF (mid([Product Number], 3, 1) = '-',
mid([Product Number], 4), [Product Number]) AS [Core Product Number], ...
Change the GROUP BY clause of the next LOAD statement into:
GROUP BY CHAN_ID, [Core Product Number];
That's about it.
Peter
Thanks for your support Peter,
Could you please send me sample application.That would be more helpful.
Regards,
Munna