Display message per selection

[#1]

Hey guys,

From the table below the goal is to have sales every month for all the shops shown on the right. But if for example when selecting a shop in this case Hilltop 58 and there are months without any sales as in the case  of Mar, Jun, Oct and Dec, then a message should be displayed saying " There were no sales in the months of Mar, Jun, Oct and Dec for Hilltop 58".

Please any help on how to achieve these will be great.

Month              Sales

Jan                  € 2,500,25

Feb                  € 1,252,00

Mar

Apr                    € 500.25

May                  € 3,500,95

Jun

Jul                    € 4,652,85

Aug                    € 10,458,87                                          SHOPS

Sep                    € 15,896,45                                        Hilltop 58

Oct                                                                              T- Square 45

Nov                    € 25,875,65                                        Spring bell 38

Dec                                                                              Down beach 10

                                                                                    Coastal city 5

Thanks in advance.

[Digvijay_Singh]

Hi,

Couldn't respond due to some urgent thing I am dealing with. Can you elaborate more, I really didn't understand what are you trying to do. how are you saving values in excel table, I think I am missing the context here, can you share the script, screen etc to know the details further.

Regards,

DJ

[#3]

Hi Digvijay,

Sorry for getting back to you so late was caught up with some work.  So in the screen below here is what I am trying to achieve. If you enter a customer name, projectCode and LocationID and click on the save button, then the information entered in the input boxes should be saved in the respective columns in the table. So please check maybe I am doing it wrong or the logic is not right.

So I created these variables vcustomer, vProjectCode , vLocationID,vSave = 0 and vFirstReload = 1 .

So now in the script I have the following

ConnTableA:

LOAD

     Customer,

     LocationID,

     ProjectCode

FROM

ConnTableA.xlsx

(ooxml, embedded labels, table is Blad1);

// Load entered information

ConnTableA:

LOAD

'$(vcustomer)' as Customer_Name,

'$(vLocationID)' as LocationID,

'$(vProjectCode)' as Project_Number

AutoGenerate (1);

//If save button is clicked

if $(vSave) then

  SET vSave=0;

  SET vFirstReload=1;

  //Load excel that has been stored

  //Check size of excel

  LET vSize = filesize('ConnTable.xlsx');

  //If the excel exists

  IF Not IsNull(vSize) then

  ConnTable:

  LOAD *

  FROM

  ConnTable.xlsx;

  END If

  //Store table into excel

  STORE ConnTable into ConnTable.xlsx;