Forum Discussion
Helper ICannot see duplicate tables
I was able to replicate the issue by duplicating a query and apply "Close and Load", without making any changes to the duplicated query.
Not only with csv input, but also with other queries.
My best guess would be that it is related to lazy evaluation, as the duplicate is exactly the same as the original.
As soon as make any changes to the duplicated query, it loads normally.
So the question is why you would want to have 2 queries that are exactly the same?
Helper IHi v-huizhn-msft,
Yes, I've clicked apply. This has been happening for any csv I have tried to duplicate not just this one.
I have worked around the issue but I'd still like to figure out what was causing it.
Thanks,
Conor.
Community ChampionI was able to replicate the issue by duplicating a query and apply "Close and Load", without making any changes to the duplicated query.
Not only with csv input, but also with other queries.
My best guess would be that it is related to lazy evaluation, as the duplicate is exactly the same as the original.
As soon as make any changes to the duplicated query, it loads normally.
So the question is why you would want to have 2 queries that are exactly the same?
- ConorHG
Thanks for the help.
I am trying to use this table as a lookup for several columns in my original data table. These columns contain the same data but could have different values at one time, hence using the same queries.
From what I understand I can only use 'related' when I have a relationship between two tables. Can you only use one relationship at a time from the same column?
So I found this the easiest way without merging the data to the one file first.
Thanks,
Conor.