Discussion Board for collaboration on QlikView Scripting.
I'm having now a problem with using similar field names in different tables.
Some of redundant field names are not supposed to be key fields.
Btw, QV does automatic joining for the tables with same field names.
How can I unspecify the key fields in the script for not using them for joining tables.
Would be much appreciated and thanks a lot for your help
It might be a bit of a hassle, but you can always rename the fields temporarily for joining purposes.
thanks for your reply.
Btw, the problem is that I have the similar field names from different source tables, but want to show them in the same table (the same column in the same field name) without letting them to be a join key.
So you want to concatenate the tables? Then look into CONCATENATE load prefix.
thanks for all the answers,
Btw, I figured out the solution by reordering Load Script table,
I loaded the same table again (repopulate) with INNER JOIN command, if i want to join it.
After that I can use Concatenate function, at the bottom of script.