Forum Discussion
Excel and datasbase data does not get realted.
Hi Need Help, I am stucked in an issue where I have one spreadsheet as dataset and I have a SQL query which is bringing data. In both these data set I have Product name and when I create relation...
AnonymousI created a spreadhseet which has all the unique product which are there in Query 1 and Append 1 and made a relation of query 1 product with spreadhseet product and spreadhseet product with append 1 product but when I use the date filter from Query 1 the value does not change it remains the same. Means nothing changes because of the filter in the table where I have the product and there values.
afaque03,
The issue could be caused by incorrect relationship, please share sample data of your tables so that I can test.
Regards,
Lydia