Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Replacing Data in Source File from Another File

johnnyycchan
7 - Meteor

HI all,

 

May I know how to update the status with field "Attend" in the file named Test11 by using file named "Test12"? The corresponsing files have attached for information. 

 

The desired result should show as follow : 

 

Before in Test11 : 

NamePositionAttend
AlanManagerNo
BenOfficerNo
CharlesOfficerNo
DavidSupervisorNo
EddieClerkNo
FannyWorkmanNo

 

 

After in Test11 : 

NamePositionAttend
AlanManagerNo
BenOfficerYes
CharlesOfficerYes
DavidSupervisorYes
EddieClerkNo
FannyWorkmanNo

 

Thanks.

 

Best Regards,

Johnny

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@johnnyycchan 
We do a Join and union the two data streams afterwards.

0928-johnnyycchan.png

johnnyycchan
7 - Meteor

It works now. Thanks a lot.

Labels
Top Solution Authors