Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table a:
Load
Keyfield,
Name;
Table b:
Load
Keyfield,
Name;
Table c:
Keyfield,
Name;
Table d:
Keyfield,
Name;
Need to show count of field -Name(values are different)
you need to show what your source data is and what you expect the output to be.
the script above will not work and its hard to understand just by looking at your script what you are trying to do
Below is the Script &expected output and source data image uploaded.
Table a:
Load
Keyfield,
Name;
Table b:
Load
Keyfield,
Name;
Table c:
Keyfield,
Name;
Table d:
Keyfield,
Name;
Need to show count of field
A solution would be to concatenate all the tables.
i agree with Sabrina, however, you have a more fundamental problem, your script is wrong you must have a source - thats really what you need to fix. concatenation will come naturally - Qlik will automatically concatenate these tables. however having said that, i would still explicitly concatenate them.
in the above image we can use the fields from specific table and insert them by selecting the required table and field
and other method is that we can use the concatenate function then all the no of rows will be appended