select value from a particular cell
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Pls. help on the below.
Input 1: contains 2 cols. where sales is blank (needs to be populated from input 2 & INPUT 3).
Country | sales |
India | |
Japan |
Input 2: no common identintifier btwn. input 1 and input 2/3. However from a day to day process perspective I knew I need to pick a particular cell value from input 2 and it is not going to change in the near future. (let us assume that value is always from B1 which is 25)
SNO | A | B |
1 | 15 | 25 |
2 | 45 | 19 |
Similarly I have another input to pick out value for japan which is A2 (in this case it is 40)
SNO | A | B |
1 | 10 | 20 |
2 | 40 | 100 |
Final output
Country | sales |
India | 25 |
Japan | 40 |
Is there a way we can handle it in altyerx.
Thanks in advance.
Srinivas
- Labels:
- Topic of Interest
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SrinivasanSugumaran ,
Picking a specific value for each country would be pretty simple using Select and Filter tools. However, I think what you're looking for is something a bit more sustainable and that would work on a larger scale.
I've put together a rough proof-of-concept for an approach that uses a mapping table:
For each input data source, we first name the dataset and create a table that shows us the cell reference of each value:
Dataset | CellRef | Value |
1 | A1 | 15 |
1 | B1 | 25 |
1 | A2 | 45 |
1 | B2 | 19 |
Dataset | CellRef | Value |
2 | A1 | 100 |
2 | B1 | 20 |
2 | A2 | 40 |
2 | B2 | 100 |
We then populate a mapping table with the cell references and dataset IDs for each country, and use a simple join to get the relevant values:
Country | Dataset | CellRef |
India | 1 | B1 |
Japan | 2 | A2 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you very much. Let me try it with a larger data set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jamielaird ,
Another clarification pls.
How to colour a particular cell from the output fetched.
Thanks
Srinivas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You need to use the table tool in order to colour cells. This article has a workflow inside that will show you how to colour cells.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Table/ta-p/49555
