Hi All,
I wanted to replace a Calc value to source data that I have, however I tried using the Find and Replace tool I am unable to get the result.
Below is my problem statement.
Calc | ||||||
Level | Division | Region | Category | Metric Type | Lookup | Value |
Market | ABC | KA | Credit Card | CIBIL Score | Market'ABC'KA'Credit Card'CIBIL Score | 2.38 |
Market | ABC | KA | Credit Card | Result | Market'ABC'KA'Credit Card'Result | 1.35 |
Market | ABC | KA | Credit Card | Type | Market'ABC'KA'Credit Card'Type | 3.2 |
Market | ABC | KA | Credit Card | Opp | Market'ABC'KA'Credit Card'Opp | 4 |
Source Data | ||||||
Level | Division | Region | Category | Metric Type | Lookup | Value |
Market | ABC | KA | Credit Card | CIBIL Score | Market'ABC'KA'Credit Card'CIBIL Score | 2 |
Market | ABC | KA | Credit Card | Result | Market'ABC'KA'Credit Card'Result | 2.3 |
Market | ABC | KA | Credit Card | Type | Market'ABC'KA'Credit Card'Type | 1.23 |
Market | ABC | KA | Credit Card | Opp | Market'ABC'KA'Credit Card'Opp | 5 |
Result | ||||||
Level | Division | Region | Category | Metric Type | Lookup | Value |
Market | ABC | KA | Credit Card | CIBIL Score | Market'ABC'KA'Credit Card'CIBIL Score | 2.38 |
Market | ABC | KA | Credit Card | Result | Market'ABC'KA'Credit Card'Result | 1.35 |
Market | ABC | KA | Credit Card | Type | Market'ABC'KA'Credit Card'Type | 3.2 |
Market | ABC | KA | Credit Card | Opp | Market'ABC'KA'Credit Card'Opp | 4 |
Thank you
Shiva
@shivanand612 , you can use the Find and Replace tool to lookup your 'Lookup' field and append the Value field. See the attached