Hi everyone,

I wrote this code to load different sales files by month:

FOR i = 1 to 12

    // Generate file name based on month
    LET vMonth = Pick(i,
        'january', 'february', 'march', 'april', 'may', 'june',
        'july', 'august', 'september', 'october', 'november', 'december'
        );
    
    trace $(i);
    trace $(vMonth);
    // File path 
    LET vFile = 'lib://MyData/sales_' & vMonth & '.csv';
    trace $(vFile);
    // Load data from file
    Sales:
    LOAD
        Date,
        Product,
        Amount,
        Price
         FROM [$(vFile)]
(txt, utf8, embedded labels, delimiter is ';', msq);

NEXT i

If I only have 2 files (e.g "sales_january.csv" and "sales_february.csv") in MyData directory, I get a "Cannot open file 'lib://MyData/sales_march.csv' error.

How can I load only existing files without getting this error?

Thanks in advance for your help,
Jose

I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?

Cheers people

I am facing an issue while trying to calculate this on the front end this type of results.

The income data is A:C - result E:G columns.

I need to COUNT the DISTINCT number of Barcodes according to the Manufacture minimal Rating.

Thank you in advance for helping me out!

TLDR : I want to access an Excel file based on a sharepoint path I give manually.

What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents. 

You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable. 

So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.

Any other idea would help.

Thanks in advance,

Maxim Perolle

Hello, 

I have created 2 alternate states: Group A and Group B (you can select different date intervals). Easily created columns Price Group A, Quantity Group A, Price Group B, Quantity Group B. But then I need a result that depends on both groups.

In more detail, as a result, I need to multiply price and quantity (two different results according to the group selection), but that should only multiply those rows that contain info in both chosen alternate states. As in the example below, only in red marked rows should be multiplied. That's where I've been stuck for more than one hour with my head spinning. Any ideas, how to handle this multiplication formula (Group A Result and Group B Result)? 

Thank you!

is it possible to show delta (difference) as negative vertical bar below x axis in case of time dimension

example time1 = 90 minutes, time2= 35 minutes, delta is 35-90=-55 minutes

like below shown for - 55 minutes