Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

FX - Salesforce

JDong
アステロイド

Hi Team, 

 

Thanks to @RolandSchubert 

 

I have a similar situation where I can surely reuse the same flow for FX conversion from USD -> EUR in my Salesforce scenario

 

My problem statement in short..same to the below post

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Currency-Conversion/td-p/496216

 

The flow is reattached in this question with a description

 

In my use case I need help to update the flow to do one additional join on the below condition


If ISClosed (File A) = True

   AND Close_date (File A)  = StartDate (Same Month) File B

   THEN use FX_USD (File B)

 

ELSEIF
ISCLOSED = 0 then FX_Rate (File C)

 

DigitMac_1-1620243734345.png

 

Thanks !

 

 

 

 

 

 

1件の返信1
TrevorS
Alteryx Alumni (Retired)

Hello @JDong 

Did the solution in the post you attach work for you?

Can you please provide your workflow and some sample data?

Please provide more information as to what steps you have taken to troubleshoot this issue so far.
Once you provide the workflow and some additional information, the community will be able to help you troubleshoot this further!

Thanks,

TrevorS

Community Moderator
ラベル