Forum Discussion
Adding Manual Data
I have a data source I'm connected to that I want to manually add data to. I have the missing dates and want to enter them into this table, but I don't see any other way except replacing all null values with the same value which isn't what I want. Is there any other way to do this?:
I assume your another source have a column which can link these two tables.
You can bring your 2nd source in your data model and then you can use "merge queries" feature to link your original source table with 2nd table and get the date from your 2nd source table.
I Hope this will get you started, if you need more info, please let me know.
3 Replies
Are you planning to update data or add new rows? Your question is not very clear.
parry2k I just want to add data. My original source is missing the end dates. I have another source that has the end dates I need for this table, so if I can populate it from that, that would be nice. But I just didn't know if I was able to edit a table and physically enter in the end dates for each of these entries since I have them.
I assume your another source have a column which can link these two tables.
You can bring your 2nd source in your data model and then you can use "merge queries" feature to link your original source table with 2nd table and get the date from your 2nd source table.
I Hope this will get you started, if you need more info, please let me know.