Index Function & OffSet Function combination

Hello All,

Happy Easter!!

I am struggling with one query in Alteryx and it is quite huge to post here so I am attaching sample data for the reference. In attached file I have two tabs first one where I need to input the data. In reality these are two separate files. I have mentioned the cell references in expected output for understanding.

Please help.

Thank You in advance.

Book4.xlsx

Developer

Accepted answers

grossal

Hi @BhatiaSakshi,

I think I understand what you mean by now. I got a rough draft for you:

Output:

What's missing:

- Filter out not needed columns

- Rename Columns to match required column-name

- Do the Multiplications

Workflow attached. Let me know what you think.

Best

Alex

2020-04-14-Index Function & OffSet Function combination.yxmd

All comments

BhatiaSakshi

Hello All,

Did anyone see the query?

Thank You,

Sakshi

grossal

Hi @BhatiaSakshi,

will you have more Countries (columns) or Codes (rows) in the future or will the all the data always have this exact shape?

It's probably pretty easy to find a solution that works on this dataset, but it will be hard if we need to make it dynamic. I'll work on a solution when this is clarified.

Best

Alex

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703