Forum Discussion
Relationship Between 2 Data Sources - Add 1 column from 1 source to the other
You'll probably need to show another example to demonstrate your new issue.
For your last comment "I don't have any blanks in table 2 for dates", your initial post stated that you did. I'm not sure how many rows you are dealing with, but Query Editor only shows a sampling of data and blank date fields may or may not be in your sample, regardless, you can still apply the replace values step.
However now when i do this (show items with no data), i am getting duplicates in my visual table. Steps I am taking are as follows below. I would like to have this column 'date' added in my visual table without pulling in duplicates of ID values.
Steps
1.) Visual table created of Table 1 shown above
2.) Create a relationship between the 2 tables
3.) Add date column into visual table (so now we have values from table 1 and table 2 together in visual)
4.) Duplicate values in the ID column now exist in the visual table.
I dont have any blanks in table 2 for dates to replace null values with 1/1/1900 in the query editor unfortunately.
Thank you!
You'll probably need to show another example to demonstrate your new issue.
For your last comment "I don't have any blanks in table 2 for dates", your initial post stated that you did. I'm not sure how many rows you are dealing with, but Query Editor only shows a sampling of data and blank date fields may or may not be in your sample, regardless, you can still apply the replace values step.