Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to unspecify key field in QV

Hello,

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

4 Replies
Not applicable

How to unspecify key field in QV

It might be a bit of a hassle, but you can always rename the fields temporarily for joining purposes.

Not applicable

How to unspecify key field in QV

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.

MVP
MVP

How to unspecify key field in QV

So you want to concatenate the tables? Then look into CONCATENATE load prefix.

Not applicable

How to unspecify key field in QV

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.

Community Browser