| Excel1enter image description here Excel2 enter image description here output expected in tableau enter image description here |
|---|
I am having two data sources. One is Excel_1 and other coming from Excel_2. Now I have to extract some rows' data from each of the data source. For that, I used Fixed LOD with IF statement.
{Fixed [City], [Week number]: sum(if [city]='London' then [poplation_1] else [Population_2] end} The output in tableau is not taking data from excel_1
So for London, I need to get data from Excel _1 but remaining city I want to get data from Excel_2.
One more condition is excel_1 has some wrong data for another city, except London, so I want to replace that wrong data from Excel_2 sheet data. For more understanding please use 'output'
Sheet in Excel (attached below). I am getting here is all city data, except London data.
Please guide me through the issue. For more clarity please use this link: https://community.tableau.com/s/feed/0D58b0000Aibp07CQA
