Can you provide the data files for 1/2 stocks so that we can see how the data is structured?

Would something like this help?

You can select one or more stocks, select the metric for comparison over the required period.

Note: I manipulated the data for stock 1 and saved it as stock 2.

You can manage with 1 data source, and do a union of the data files as shown below.

Hi

You can either apply Union as Hari mentioned above or you can use blend option. I would recommend the union option. You don't need to have separate data sources for each csv as it will be an overhead to maintain and also limits the analysis you can perform.

Regards

Vishnu

If you have too many files, I wouldn't recommend a join. Also, in your case, I am wondering what you will achieve with a join since it will only add new columns and not add new rows for a stock.

I don't think joins will work for you. As mentioned above, you should have a set of rows for each stock, and not 1 set of rows for all the stocks.

Yes. I have attached a 10.2 workbook and screenshots of what can be done. You can explore with your data files.

You are welcome. If you do not have any further questions, please close this thread.