Forum Discussion

afaque03's avatar
afaque03
Helper I
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

afaque03,


Could you please share sample data of append1 table and Query1 table here? Does the Append1 table contain all the possible product name values of Query1 table?

Regards,
Lydia

afaque03's avatar
afaque03
Helper I
8 years ago

AnonymousNo the no. of prooduct in query is more as compared to the no. of product in Append.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    afaque03,

    The issue is related to the values. Please create a new bridge table containing all possible product name values of Append table and query table, then delete the existing relationship between append and query tables, create relationship between bridge table and append table, and create relationship between bridge table and query table.

    Regards,
    Lydia

    • afaque03's avatar
      afaque03
      Helper I
      8 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        afaque03,

        The issue could be caused by incorrect relationship, please share sample data of your tables so that I can test.


        Regards,
        Lydia