Adding data in excel column

[adarsh2608]

Hello All,

I have a excel in which have list of data out of which i want alteryx update in column E with status " available DD/MM/YYY" if the name belongs to current month for example Sep-22

[DataNath]

@adarsh2608 is this what you're after? Wasn't sure what you wanted if this condition isn't met so just went with null() as is fairly standard. This expression makes use of the DateTimeNow() and DateTimeMonth() functions to check whether the months of the date are the same as the current month:

Small edit: Realised I'd provided the output in MM/DD/YYYY rather than DD/MM/YYYY - attached flow amended.

[Luke_C]

Hi @adarsh2608 

@DataNath  beat me to it, but totally agree with his solution:

[Emmanuel_G]

@adarsh2608 

Find attached the way of doing this.

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped.

[adarsh2608]

Hello @Emmanuel_G , @Luke_C , @DataNath .

I want to write the data in the same input excel . Can you help me on that 

[DataNath]

@adarsh2608 when you come to output the file, use an Output Data tool after a Block Until Done. Pick your file by going 'Write to File or Database' > locate file > confirm sheet > Under option 3 (Output options), set this to 'Overwrite File (Remove)' and it will overwrite the incoming Excel:

[Emmanuel_G]

@adarsh2608 

Updated version