Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 tables , a, Transactions table and a Sales Persons table , as shown below. The common field between the 2 tables is the Document number.
I am uncertain how to merge the 2 tables so that in my table viewer i want to see 1 table.
I have attached
Please can you help.
Thank you .
Transactions Table | ||
Document | Customer | Value |
1 | A | 200 |
2 | B | 500 |
3 | C | 300 |
4 | D | 200 |
5 | E | 300 |
Sales Person Table | |
Document | Sales Person |
1 | Dave |
2 | John |
3 | Mike |
4 | Dave |
5 | Gary |
Hi Jonathan
Thank you for the feedback. I'm using the ApplyMap (the same that Sweuhl suggested) and see if it works.
Will let you know the outcome.
kind regards
Nayan
Hi Jonathan
The figures are still doubling. Is it because its the same sales persons in both transactions table, or should this not have an effect?
kind regards
Nayan
Hi Nayan,
By using ApplyMap() your data will not be doubled the other way is try like this
Transactions:
LOAD *
From Transactions1;
Concatenate(Transactions) -- Except SalesPerson load all columns
LOAD ...
DocumentNo
...
FROM Transactions2;
SalesPerson:
LOAD DocumentNo, SalesPerson
FROM Salesperson;
Concatenate(SalesPerson)
LOAD DISTINCT
DocumentNo,
SalesPerson
FROM Transactions2;
Hope this helps you.
Regards,
jagan.
Hi Jagan
I'll check my links again on the App Map() . However i will try your method and let you know. Thank you for the feedback.
kind regards
Nayan
Hi Jagan
Your scripting works perfectly. Also the App Mapp scripting worked as well. Thank you Jonathan & Swuehl for showing me App Mapp and will definitely be using this in the future.
kind regards
Nayan
Hi All
I forgot to mention why the Apply(Map) did not work initially is a silly mistake on my side not having the proper joins in my original scripting. Otherwise it works perfectly.
kind regards
Nayan