Columns and Pivot Tables Designer Help!

Question

Hi everyone, I am trying to better understand designer. I assigned myself a little project, which I think would be beneficial for my team at work. So, we receive an excel sheet daily, the file contains different data everyday. The first image "Capture" shows the daily excel file that I receive. In the second image "Capture 1", is a list of columns with information that is derived from the first image attached. These columns are formula driven, mainly VLOOKUP and conditionals. Is there a way to automate this in Alteryx? Thank you for the insight!

Capture.PNG

Capture 1.PNG

CoG · Answer

Add an extra 'I' and change the I3 to the name of an Alteryx Column and you have yourself a Formula Tool formula that will do exactly that:

IIF([Numeric Column]<16,"0-15 days",
IIF([Numeric Column]<31,"16-30 days",
IIF([Numeric Column]<61,"31-60 days",
IIF([Numeric Column]<91,"61-90 days",
IIF([Numeric Column]<121,"91-120 days","Over 120 days")))))

KevinQVo · Answer

Thanks, any tips for condition formulas?

For example: =

IF(I3<16,"0-15 days",
IF(I3<31,"16-30 days",
IF(I3<61,"31-60 days",
IF(I3<91,"61-90 days",
IF(I3<121,"91-120 days",
IF(I3<2000,"Over 120 days"))))))

binu_acs · Answer

@KevinQVo The Excel lookup functionality can be achieved using the find and replace tool or join tool, you can experiment with either of these tools.