look up and join with current date and day

Hi Guys,

Am quite new to alteryx. I need suggestion on this-

there is one id which is functional in (mon,tues) and there is another id which may be functional in (mon,wed). So i need to create a column which should match up the day in the other file ( where only date is there) and if that Id is not mapped in that particular day then there should be a flag.

In short i have day in one file and date in other file with a common key available. How should i create a look up in this?

Let me know if it is clear or not.

Thanks in advance folks!

Datasets

Developer

Join

Database Connection

Accepted answers

danilang

Here you go

Solution v2.0.png

Dan

datedatejoin v2.0.yxmd

All comments

Kenda

Hi @ankitpaul7!

I'm not sure I understand your problem fully so if you could provide a sample of what your data looks like now and what you want it to look like after, that would be very helpful.

From what it sounds like, though, you should try the Join tool (in the preparation category). Use your id field to join on. The records that have the same id from both input files will come out the J output. The ones that don't have a common id between the two inputs will fall out the L or R. From there, you can add a formula with a flag then Union the records back or something.

Hope this helps!

danilang

I'm not quite sure what you're trying to accomplish

Can you post some sample data? Even just in tables would be enough. ie.

mon	A
tues	B
wed	C

With samples of both of your input tables, we should be able to come up with a solution

Thanks

Dan

ankitpaul7

file1.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703