In some situations when even though the columns and their name from the two tables are the same, you may want to treat them differently and don’t want to concatenate them. So Qlik Sense provides the NoConcatenate keyword, which helps to prevent automatic concatenation.
Let's see how to write the script for NoConcatenate:
You should handle the tables properly; otherwise, the output of NoConcatenate may create a synthetic table.