Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have an app used to monitor price list over time. I want to observe both general situation as well as details by list of products. But because the data is huge, I just take needed information by uploading file included required product code. Hence, I build 2 models in my app:
- Model 1: grouped information used for general visualization
- Model 2: uploaded product list
Now what I want to know is how to switch between 2 models with the logic: if a product list is uploaded, use model 2 to run all visualization sheets, else use model 1
Is there any way to do so?
Thank you!
if both the models are independent and their script do not depend on each other at all, then you can write an if condition to check if product list file is uploaded at a location and run model 2 script. else run model 1 script.
If the product list is uploaded in excel, you can use similar logic as below:
let vFilePath='lib://Product list/Prod1.xlsx';
for each file in filelist('$(vFilePath)')
FileList:
load
'$(file)' as FileName,
filetime('$(file)') as FileTime
autogenerate 1
next
let vFileCount = NoofRows('FileList');
// if condition started
if '$(vFileCount)' > 0 then
// Add model 2 code here
else
// Add model 1 code here
endif
Regards,
Aditya