2 of 2 people found this helpful
I would suggest after data->new data source->added 2.csv that you then edit the 2.csv data source and join it to 1.csv. Then you can use the replace data source option. This should be a cleaner replacement as the two data sources should be identical.
For #2, I am unclear on what you mean. Can you add screenshots or a workbook to show what issue you are experiencing?
Sure. I will post images/dashboard in a few hours. thanks.
I added both csv. Joined them. Replaced the joined with the current joined excels. It worked.