topic Re: Need help joining tables by transaction ID! in QlikView

Need help joining tables by transaction ID!

Wed, 22 Jul 2015 23:14:50 GMT

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

Re: Need help joining tables by transaction ID!

ramoncova06 — Thu, 23 Jul 2015 00:00:58 GMT

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

Re: Need help joining tables by transaction ID!

Thu, 23 Jul 2015 00:23:41 GMT

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>:

Re: Need help joining tables by transaction ID!

ramoncova06 — Thu, 23 Jul 2015 00:39:32 GMT

it does then you could use the join prefix

Re: Need help joining tables by transaction ID!

Thu, 23 Jul 2015 01:07:22 GMT

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

Check out that link for some explanation on joins.

Re: Need help joining tables by transaction ID!

sasiparupudi1 — Thu, 23 Jul 2015 06:02:40 GMT

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

Re: Need help joining tables by transaction ID!

Thu, 23 Jul 2015 12:45:54 GMT

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>: