Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm doing the load a table of my Sybase database and a table from a csv file, I need to join the two and so I know I should use the concatenate function (append queries) however as I apply the left function at this juncture of the two tables?
Solved! Go to Solution.
Question not clear - Do you just need to a left join between a) Sysbase tables & csv file table or b) do you need to append csv table to your sybase table.
If a) Then used the Relationships tab (or Manage Relationships) and set the required relationships
If b) use the "Append Queries" when loading the data
Regards.
I need to join the two and so I know I should use the concatenate function (append queries) however as I apply the left function at this juncture of the two tables?
I'm not quite clear of your question. Especially "however as I apply the left function at this juncture of the two tables", what's the specific question you have?
Question not clear - Do you just need to a left join between a) Sysbase tables & csv file table or b) do you need to append csv table to your sybase table.
If a) Then used the Relationships tab (or Manage Relationships) and set the required relationships
If b) use the "Append Queries" when loading the data
Regards.
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |