Challenge #1: Join to Range

[anay_zinje]

Trilled to solve this challenge.

Used text to column, Generate Rows tool, Formulas tool, join and summerize tool to solve this challenge 😀 

[rchaidez]

Solved using the following tools: Formula, Find Replace and Summarize

[Abinayajulius]

Enjoyed solving this challenge. I used the formula tool, join tool and summarize tool and was able to get to the output. Looking forward to solving more challenges. 

[Abinayajulius]

Enjoyed solving this challenge. I used the formula tool, join tool and summarize tool and was able to get to the anwer.  Looking forward to solving more challenges. 

[viniciusahanada]

Steps used to find solution:

1. Inspect input files for data and metadata;

2. Tile tool, manual method, 'Postal Area' as numeric column, entered "2019", "2039", "2059", "2079", "2100" as tile cutoffs;

3. Formula tool - create "Region" column and apply formula ""R" + ToString([Tile_Num])";

4. Join tool, joining by "Region" field;

5. Summarize all joins, grouping by "Region", "Sales Rep", "Responder"; and counting by "Responder"

[huyenntran97]

My solution for challenge 1:

[vijaydholam]

Done...created range with formula tool then looked up all columns from other table and then used summarize tool to get desired result.

[Tanbir89S]

Solved! Solved! Solved!

Steps to be followed to achieve the desired result:

• Connect Text To Columns Tool to LookUp Table containing range of year:
  • Delimiters as - 
  • Split to columns - Number of columns to 3
• Select Tool
  • Change the Type to Int32 from String (for newly generated columns i.e. 1 and 2)
• Generate Rows Tool
  • Create New Field - RowCount(Name of the field)
  • Initialization Expression : [1]
  • Condition Expression: RowCount <=[2]
• Insert Join Tool and connect to Fact table and output from Generate Rows tool
  • Join on Postal Area(left) and RowCount (Right)
• Select Tool 
  • Check "Customer ID", "Responder", "Region" and "Sales Rep"
• Summarize Tool
  • Group By : Region, Sales Rep and Responder
  • Count : Customer ID

Yeah!!!! You have got the desired result. Congrats!

[Kusk]

Challenge Completed.

[crukesh]

Use formula tool to include region --> Use join tool to merge both files --> Summarize tool to group by region, sales rep and responder and count customer id.