Conditinal Inputs

Question

Hello Community,

I have date field and I want to add condition based on that need to fectch input files .
Suppose I have date Q1 (between Jan -Mar) then need to take file 2 files (BT and BECFM)  and process them, if date is Q2 or Q3 then need to take one file(BT) and process them and save output.

How we can achieve this?

We need to save output file based on Date condition not for all quarters

BT_Q120220331_20221216112608.csv

BECFM_GROSS_20220331_20221216112608.csv

binu_acs · Answer

@aman_goyal One way of doing this

Quarter_Based_File_Selection_1216.yxmd

PanPP · Answer

Hi @aman_goyal

You can convert the date into specific quarters by using this expression in the formula tool: DateTimeFormat([Date],'%Y Q') + ToString(Ceil(ToNumber(DateTimeFormat([Date],'%m'))/3))

You can then use a conditional statement to process both files or one file: If Contains([Quarter], "Q1") then "Both" elseif Contains([Quarter], "Q2") then "BT" elseif Contains([Quarter], "Q3") then "BT" else "" endif

You may want to check this post out as well to see if it helps you build your workflow.