Store

[DanieleCancellieri]

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 · Accepted solution]

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]

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

[DanieleCancellieri]

Thanks!