topic Re: Store in App Development

Store

DanieleCancellieri — Fri, 24 Sep 2021 16:15:06 GMT

Hi, i have to do a store with some days given by an Excel file. How do I have to have a variable equal to a day? I think so:

load*inline [
month, day
sep, 24/09/2021
oct, 25/10/2021];

Let vtoday = date(today(), 'DD.MM.YYYY');
let vmonth=month(today());

if $(vtoday)= '24/09/2021' then

store [table] into 'lib://....._$(vmonth).csv' (txt,delimiter is ';');

rubenmarin — Sat, 25 Sep 2021 07:29:13 GMT

Hi, you can thy with:

IF Exists('Day','$(vtoday)') THEN //STORE ENDIF

Make vtoday variable with the same as the expected date, wich it seems to be:

Let vtoday = date(today(), 'DD/MM/YYYY');

Also it will be better to change 'Day' field name to another one less common and more meaningful like DayToLoadExcel

PrashantSangle — Sat, 25 Sep 2021 08:05:18 GMT

Can you explain your requirement with sample data.? We will get more clarity on it.

DanieleCancellieri — Mon, 27 Sep 2021 06:46:21 GMT

Thanks!