Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please advise on the correct code to link the following crosstable with another table. I tried join, concatenate and keep but couldn't get the answer that I was looking for.
Fund_Perf:
CROSSTABLE(Fund_ID, Fund_Perf)
LOAD Date,
[15893],
[2878],
[2882],
[10826],
FROM ...;
Fund_Info:
Load Fund_ID,
Fund_Name
FROM ...;
Thank you
Hi
You don't need. QV guess the link between the 2 tables.
Anyway, you can use a Concatenate load
// Fund_Info:
Concatenate Load Fund_ID,
Fund_Name
FROM ...;
jj
Doesn't look like Concatenate should be your answer. I'd think more along the lines of "left join". What was, however, the answer that you were looking for? It's not totally clear from your message...