In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Want to pick the data from another file ( like Vlookup)

Maheshp
8 - Asteroid

Hi Team,

 

I have a data in one file like below.

 

NameNumberBOPAmountDebitCredit Total
10X-Regel9783527509867BC.531460.010000
10X-Regel Audio9783527509874BC.531460.020000
1x1 der Kommunikation für Führungskräfte9783527507115BC.334707.010000
200 and More NMR Experiments9783527310678BC.324560.010000
2D Nanomaterials C9783527346776BC.530971.040000
3D Bioprinting C9783527347964BC.539321.010000
3D Images of Materials Structures9783527312030BC.332383.01-82.9082.982.9

 

Another File Data:- 

 

NumberPoint
9783527509867400
9783527509874300
9783527507115500
9783527310678300

 

But in another file i have " Numbers and Points only", with the help of option how can we get only POINT from that particular Number like below.

 

NameNumberBOPAmountDebitCredit TotalPoints
10X-Regel9783527509867BC.531460.010000400
10X-Regel Audio9783527509874BC.531460.020000300
1x1 der Kommunikation für Führungskräfte9783527507115BC.334707.010000500
200 and More NMR Experiments9783527310678BC.324560.010000300

 

Regards,

 

Mahesh

3 REPLIES 3
RobertOdera
13 - Pulsar

Hi, @Maheshp 

 

Please check out the options below.

 

Please mark it as an acceptable solution if it works for you - cheers!

 

RobertOdera_0-1678980335003.png

 

 

ShankerV
17 - Castor

Hi @Maheshp 

 

A simple join tool will help you to achieve the result for you.

 

ShankerV_0-1678983536129.png

ShankerV_1-1678983556479.png

 

Many thanks

Shanker V

RobertOdera
13 - Pulsar

You're most welcome @Maheshp 

Labels
Top Solution Authors