Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need help joining tables by transaction ID!

Hi everyone,

I am trying to generate a single table box, matched by the field Transaction ID which is primary key in both files.

Seems like it has something to do with the cell format in one of the files.

Should be an easy fix on the load script that I have been struggling for days and still can't find out!

Any help is greatly appreciated

Please find attached the files!

Thanks

Tags (2)
6 Replies
ramoncova06
Not applicable

Re: Need help joining tables by transaction ID!

do you want to join the data ? or concatenate it ?

the are different things, join will work as your regular sql joins and concatenate will append the data to a table, but it will not populate any previous fields

Not applicable

Re: Need help joining tables by transaction ID!

Thanks a lot Ramon for your quick response.

I guess I would like to join the data.

Just to make sure I am getting it right, I would like to have one unique

transaction ID in each row, with the different cooumns gathered from the 2

files.

Does that make any sense?

Thanks a lot again

2015-07-22 21:01 GMT-03:00 Ramon Covarrubias <qcwebmaster@qlikview.com>:

ramoncova06
Not applicable

Re: Need help joining tables by transaction ID!

it does then you could use the join prefix

Not applicable

Re: Need help joining tables by transaction ID!

http://www.qlikviewaddict.com/2012/03/explaining-joins.html

Check out that link for some explanation on joins.

sasiparupudi1
Not applicable

Re: Need help joining tables by transaction ID!

Please check the file and let me know if this is what you are looking for

Not applicable

Re: Need help joining tables by transaction ID!

I have checked the file and is exactly what I am looking for.

One single row for each transaction ID.

However, as I reload the script, I lose that format. It "unjoins"

Weird.

2015-07-23 3:03 GMT-03:00 Sasidhar Parupudi <qcwebmaster@qlikview.com>: