Return quantities based on text in product description

[SteveBorwell]

Hi

So I have my 2 tables joined without issue and have created my pivot table with dimensions and measures. So I want to limit the data loaded from the tables in the script to just include quantities received or picked where the product description contains FSC.

I have tried a variety of solutions that are similar to what I require but all that seems to happen is data fails to load from one of the tables.

Any help appreciated.

[Soundarya]

Can you post either a file or picture with sample data?

[Ksrinivasan]

hi,

Load

*,

FROM [lib:// \QAMB*.XLSX]
(ooxml, embedded labels, table is Sheet1)

Where WildMatch(MBLNR,'50*');

replace your values with above function.

MBLR =  product description field,

50 = FSC

ksrinivasan

[SteveBorwell]

@Ksrinivasan I have already tried that option thanks to Google but all that happened was it didn't load any lines from my products qvd.

@Soundarya here are the images from my script.

hope that helps.

[Ksrinivasan]

hi,

from my learning,
once again we have to reload after joint (Product and gun) qvd.

while loading your condition will work.

ksrinivasan

[SteveBorwell]

@Ksrinivasan I'm sorry I don't understand.

[Ksrinivasan]

hi,

1. store your joined table as qvd file:

Table1 + Table 2= stored in Table3.qvd

drop Table1 and Table 2,

2. Load file from Table3.qvd. Now apply your conditions

FROM [lib:// \Table3.qvd]
(ooxml, embedded labels, table is Sheet1)

Where WildMatch(MBLNR,'50*');

now it will work.

ksrinivasan.

[SteveBorwell]

But they are already separate QVDs how do I join them as one qvd?

[Ksrinivasan]

hi,

let me share my understanding about your requirement.

1. your pivot table is working fine from two table data. Table1 and Table2

2. You want to avoid unwanted data loading while loading or refreshing App.

3. You have some key point to filter the data, which you exactly want to produce result

4. you have tried many idea's filter through your key words, including where wild match. but result fail.

if, above points are yes,

1. which table contain product description which need to filter from qvd file. Table1 or Table2.

unfortunately, i never seen "product description" field from your both tables.

share your dummy data and condition,

ksrinivasan

[SteveBorwell]

Hi thanks for getting back to me.

In answer to your questions:

1. yes

2. yes

3. yes

4. correct

So stockdescription (apologies for the misdirection in the title) is the field within the products.qvd and all my transactional data is within the guns.qvd

The 2 qvds at the start of this question are the ones I am using. They are linked by the StockCode and ProductCode fields. I need to show all stock with (FSC) in the stockdescription field that has come in or been sent out of our warehouse. The measures within the pivot table are correct and working as I would expect. I just need to trim the data to just show FSC products.