Need help joining tables by transaction ID!

[#1]

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

[ramoncova06]

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

[#3]

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]

it does then you could use the join prefix

[#5]

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

Check out that link for some explanation on joins.

[sasiparupudi1]

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

[#7]

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