Two Period date for One Line Chart

[jumiprado]

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!

[sunny_talwar · Accepted solution]

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.

[sravanthialuval]

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$);

[sunny_talwar]

How is join going to create a synthetic key?