How is Join different from Concatenate?
Answer / Ishank Awasthi
Join operation merges two or more tables based on a common column (key) and creates a new table that combines the columns of all the original tables. On the other hand, Concatenate operation simply combines multiple text strings into one single string, without any regard for common values or combining columns from different tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why is the formation of a Synthetic key considered bad in QlikView?
What is the use of load statement?
What is a direct query?
What can you use as an alternative to join?
Name top 10 bi tools?
Explain binary load?
What is mini chart?
What do you mean by rdbms?
What is the difference between a list box and a multi box?
How can we drop some fields from the memory during script execution?
On what levels can you manage the settings from the Settings menu?
What is the use of connect statement?