Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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>:
it does then you could use the join prefix
http://www.qlikviewaddict.com/2012/03/explaining-joins.html
Check out that link for some explanation on joins.
Please check the file and let me know if this is what you are looking for
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>: