Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I need some help for this. I have the following tables
Client | Process ID | Bill Date | Bill Money |
---|---|---|---|
10001-0 | 58 | Jul - 05 - 2016 | 200 |
10111-2 | 2 | Jun - 17 - 2016 | 300 |
30451-2 | 1 | May - 25 -2016 | 150 |
10111-2 | 3 | jul - 17 - 2016 | 300 |
Client | Process ID | Collection Date | Collection Money |
---|---|---|---|
10001-0 | 58 | Jul - 25 - 2016 | 200 |
10111-2 | 2 | Jul - 01 - 2016 | 300 |
30451-2 | 1 | Jun - 10 -2016 | 150 |
10111-2 | 3 | jul - 27 - 2016 | 300 |
I need to make a table where i can see if the Client have been billed and Collected. If the money collected was the total for the Billed Money.
I think that if I concatenate CLIENT with PROCESS ID maybe i can relate the tables. Please help me with this!
Thanks you!
Why don't you join them instead of Concatenating them:
Table:
LOAD Client,
[Process ID],
[Bill Date],
[Bill Money]
FROM .....;
Join (Table)
LOAD Client,
[Process ID],
[Collection Date],
[Collection Money]
FROM .....;
This will put them side by side making the overall comparison easy to do.
Why don't you join them instead of Concatenating them:
Table:
LOAD Client,
[Process ID],
[Bill Date],
[Bill Money]
FROM .....;
Join (Table)
LOAD Client,
[Process ID],
[Collection Date],
[Collection Money]
FROM .....;
This will put them side by side making the overall comparison easy to do.
But it will form synthetic keys using Client and process ID.
Sunny T <span class="icon-status-icon icon-mvp" title="Mvp"></span> wrote:
Why don't you join them instead of Concatenating them:
Table:
LOAD Client,
[Process ID],
[Bill Date],
[Bill Money]
FROM .....;
Join (Table)
LOAD Client,
[Process ID],
[Collection Date],
[Collection Money]
FROM .....;
This will put them side by side making the overall comparison easy to do.
Try this
table1:
LOAD Client&' '&[Process ID] as clientprocessid,
Client,
[Process ID],
[Bill Date],
[Bill Money]
FROM
(biff, embedded labels, table is Sheet1$);
table2:
LOAD Client&' '&[Process ID] as clientprocessid,
[Collection Date],
[Collection Money]
FROM
(biff, embedded labels, table is Sheet2$);
How is join going to create a synthetic key?