Help with Table Join

[rwb139]

Hi everyone,

I am very new to Qlik Sense and am trying to figure out how to properly join these two tables. I need to have them associate on the year, month, property ids, and cash account. For cash_account, I have split it into the number and name and joined the number on the gl_acccount_number. I have also done an inner join to join the year and the property_id; however, when I do such a join, the dates get all out of whack and inaccurate.

I'm not sure how to join, or associate them to where I can have all of them correct. Thanks in advance for any guidance, and let me know if something is not clear. 

[ArnadoSandoval]

Hi @rwb139 

With the information present in both Excel files it is not possible to join these tables, there is not a single column in common between them.

hth

[rwb139]

Hey @ArnadoSandoval 

With the limited info I know it's hard to see, but on the ...728 file, I split the cash_account column into two with the numbers and then names. Those numbers match up to the gl_account_number on the ...821. The also added calculated columns for the post date of ...728 for the month and year which correspond to the year column info. Here is a pic of my ...728 file to make it more clear. Thanks for your help.