select value from a particular cell

[SrinivasanSugumaran]

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

[jamielaird]

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

[SrinivasanSugumaran]

Thank you very much. Let me try it with a larger data set

[SrinivasanSugumaran]

Hi @jamielaird ,

Another clarification pls.

How to colour a particular cell from the output fetched.

Thanks

Srinivas

[Emil_Kos]

Hi @SrinivasanSugumaran,

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