Hlookup Calculation

Question

Hi Everyone,

I want to perform Hlookup like calculation in alteryx, Find below screenshot:

Can Anyone Help, Thanks in Advance !

mceleavey · Answer

Ouch.

So the short answer here is, no. That's a really awful, manual Excel calculation with no logical format and so there's no way to relate the values.

In essence you have three tables:

Table one:

Table1         Col1---   Col2---   Col3---   Col42020101410098

Table two:

IDCol1Col1 ValCol5abc1A0.00 0002B0.60 12120122387763C0.25 505050994904D0.56 1131.20114228585E0.36 727.207343266

Table three:

IDabc10.000.26520.600.35230.250.36840.560.410.3550.3640.14

There doesn't appear to be any logic relating the things you are trying to do. This is a very Excel way of doing things.

I would recommend getting the data in a logical format, and then you can simply multiply the things together.

As it stands, you want multiply random cells. You need to make the data mean something first, and create a logical association between them.

unknown · Answer

Hi @mceleavey

Find attached file, where i have mention two tables and formula, which i want to achieve.

Thanks !

Sample Data Alteryx15.xlsx

mceleavey · Answer

Hi @Inactive User ,

can you provide some mock data of what you're trying to achieve?

Thanks,

M