Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI guys,
I am doing the following join which works perfectly..
left join (SalesLines)
Load TxnID, TxnDate Resident Sales;
It joins on TxnID.
Now i need to take all fields of Sales in Sales Lines so I wish to do something like this
left join (SalesLines)
Load TxnID, * Resident Sales;
and it does not work.
Any suggestion?
Try
left join (SalesLines)
Load * Resident Sales;
I tried that but it did not work...it did not bring any data to SalesLines.
Hi,
Have you checked there's not a single field name apart from TxnID and TxnDate that is common to both tables? That's usually the trap with this kind of "massive join".
You can also try:
join (SalesLines)
Load * Resident Sales
where exists (TxnID)
;
The result may show what causes the issue.
Hope it helps.
It gives error saying that "exists" field does not exist.
Sorry, I had forgotten the parenthesis. Edited in previous post.
Where exists (TxnID)
Have you checked there's no other field named the same way between the 2 tables?
Let us know the exact fields of both tables.... Hope you are not applying Where Exist in SQL Select load.
it does not give any error but it did not any data from sales to salesline either.
I am doing this
left join (SalesLines)
Load * Resident Sales
where exists (TxnID);
I am doing this.
left join (SalesLines)
Load * Resident Sales
where exists (TxnID);